SSIS Extract and Load

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » SSIS Extract and Load

SSIS Extract and Load

Rate Topic

Display Mode

Topic Options

Author

Message

iamsql1

Posted Thursday, January 31, 2013 12:40 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:59 AM
Points: 24, Visits: 86

HI,
I am trying to write a ssis package which moves clients file from certain directory to another.

Source Path : D:\Temp\Source\Client A_CSV
D:\Temp\Source\Client B_CSV etc

Source Directory has many folders of clients like Client A_CSV etc.

I want that when i move files to ARCHIVE directory,so that it rename the files with time stamp.

So far, i have been able to move with file task, but it does not allow me to rename file as I retrieve
FULLY QUALIFIED PATH as loop enumerates,

So,,any idea ,, how i accomplish renaming with file system task or Script Task,

Thanks

Post Attachments

1.png (0 views, 116.62 KB)

Post #1414294

Sam Vanga

Posted Thursday, January 31, 2013 6:47 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 11:47 AM
Points: 39, Visits: 264

Go through the following articles. Let us know if this still doesn't solve your question.

http://www.bidn.com/blogs/KeithHyer/bidn-blog/2465/copy-and-rename-a-file-in-ssis-using-the-file-system-task

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html

~Sam.

http://svangasql.wordpress.com

Post #1414420

iamsql1

Posted Friday, February 01, 2013 3:51 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:59 AM
Points: 24, Visits: 86

a bundle of Thanks

Post #1414552

opc.three

Posted Friday, February 01, 2013 7:03 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:59 AM
Points: 6,703, Visits: 11,732

It is a lot of work to do this in SSIS. Do you have to use SSIS? You could do this with a single line of PowerShell too.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1414659

iamsql1

Posted Thursday, February 14, 2013 4:56 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:59 AM
Points: 24, Visits: 86

i have a new problem .

i am writing ssis package having For Each Loop Container Which iterates through DropBox Folder ..

But when it iterates, it gives error : Desktop.ini File in DropBox is not Recognized.

How do i ignore this .ini file while iterating through Dropbox ?

Post #1419986

Phil Parkin

Posted Thursday, February 14, 2013 5:15 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 4,238, Visits: 9,480

iamsql1 (2/14/2013)

Please do not cross-post. Answers here please.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1419995

« Prev Topic | Next Topic »

Permissions