dbTalk Databases Forums  

DTS Example: Import CSV copy rename delete file...

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Example: Import CSV copy rename delete file... in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JDP@Work
 
Posts: n/a

Default DTS Example: Import CSV copy rename delete file... - 10-17-2005 , 11:53 PM






Seeking example of DTS script to consume a csv file, rename & copy it to an
imported folder.

TIA

JeffP....



Reply With Quote
  #2  
Old   
Rodney Mullins
 
Posts: n/a

Default Re: DTS Example: Import CSV copy rename delete file... - 10-18-2005 , 12:03 AM






http://www.sqldts.com/default.aspx?292

JDP,

I think you can pull the rest of it together.. based on the great examples
from Darren Green.. Good Luck and I hope this helps.


--
Rodney Mullins
rodney_mullins (AT) msn (DOT) com


"JDP@Work" <JPGMTNoSpam (AT) sbcglobal (DOT) net> wrote

Quote:
Seeking example of DTS script to consume a csv file, rename & copy it to
an
imported folder.

TIA

JeffP....





Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTS Example: Import CSV copy rename delete file... - 10-18-2005 , 12:45 AM



Hello Rodney,

".. based on the great examples from Darren Green"


Are my articles not great? <grin>


Allan



Quote:
http://www.sqldts.com/default.aspx?292

JDP,

I think you can pull the rest of it together.. based on the great
examples from Darren Green.. Good Luck and I hope this helps.

"JDP@Work" <JPGMTNoSpam (AT) sbcglobal (DOT) net> wrote in message
news:eDSdJ750FHA.3376 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Seeking example of DTS script to consume a csv file, rename & copy it
to

an

imported folder.

TIA

JeffP....




Reply With Quote
  #4  
Old   
Rodney Mullins
 
Posts: n/a

Default Re: DTS Example: Import CSV copy rename delete file... - 10-18-2005 , 11:12 AM



Sorry, Allan. Yes, your articles are great as well. I'm hoping one day I
can write some great articles. How do I go about doing this for
SQLDTS.com?

Rodney
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:
Hello Rodney,

".. based on the great examples from Darren Green"


Are my articles not great? <grin


Allan



http://www.sqldts.com/default.aspx?292

JDP,

I think you can pull the rest of it together.. based on the great
examples from Darren Green.. Good Luck and I hope this helps.

"JDP@Work" <JPGMTNoSpam (AT) sbcglobal (DOT) net> wrote in message
news:eDSdJ750FHA.3376 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Seeking example of DTS script to consume a csv file, rename & copy it
to

an

imported folder.

TIA

JeffP....






Reply With Quote
  #5  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTS Example: Import CSV copy rename delete file... - 10-18-2005 , 03:23 PM



Hello Rodney,

Contact one of us offline.

Allan




Quote:
Sorry, Allan. Yes, your articles are great as well. I'm hoping one
day I can write some great articles. How do I go about doing this
for SQLDTS.com?

Rodney
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:f0343b03527c8c7a1c6aaa001f0 (AT) msnews (DOT) microsoft.com...
Hello Rodney,

".. based on the great examples from Darren Green"

Are my articles not great? <grin

Allan

http://www.sqldts.com/default.aspx?292

JDP,

I think you can pull the rest of it together.. based on the great
examples from Darren Green.. Good Luck and I hope this helps.

"JDP@Work" <JPGMTNoSpam (AT) sbcglobal (DOT) net> wrote in message
news:eDSdJ750FHA.3376 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Seeking example of DTS script to consume a csv file, rename & copy
it to

an

imported folder.

TIA

JeffP....




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.