Since the operation involves remote server...there will be issues related with user authorization.

An approach could be as follows:

Using FTP Task bring the files --> Edit the files using FST -->...

You might want to check\edit the following file once:

Drive_Letter:\Program Files\Microsoft SQL Server\100\DTS\ProviderDescriptors\ProviderDescriptors

Even I'm curious...

Happy to help....

Whose on facebook...on a lighter note...:-D:-D:-D

Phil Parkin (8/18/2010)

---

veera.1255 (8/18/2010)

---

Report Designer: Supports the report creation phase of the report lifecycle. It is an add-on tool for any edition of Visual Studio .NET 2003, suitable for both...

This will lead to dependancy...don't you think so!!!;-)

Siddharth,

Foreach with one scipt task and EST. Loop parameters ki value...name of server will change upon some condition....now we have a server name...script task and EST...easy...but remember to set DelayValidation...

Well the best approach should be to club multiple columns and split the data accordingly, what say brother???

Consider this you have 100 distinct id's...by your approach i wil land up having 100 text files and not 100 data flow tasks to load in to SQL tables

This is...

Ravi,

Note: This description is worth implementing only if we have limited number of distinct ID's say at maximum I would bet on 10.

Incase, we have more, please refer later section.

Your...

Sharath,

Step 1: Assign a source file connection

Step 2: Create a variable and assign it a value+Extension

Step 3: Create a FST(File System Task) in rename file mode

Step 4: Use a variable...

Siddharth,

Have you considered using SMO approach.

This could be tedious as you will land up designing the entire component itself.

Baskar B.V (8/13/2010)

---

tripower (8/13/2010)

---

I wanted to create a pause with a warning message at the beginning of certain packages due to the potential impact on the database. How would I...

Phil Parkin (8/10/2010)

---

Here[/url] is a nice article, though probably not applicable to your scenario. Worth a read anyway.

Code reuse in SSIS is not as easy as it could be. To...

Hi,

ideally you should filter the records at Query level.

Add a filter clause to your T-SQL statement and later deployt the dataset to reporting service.

As a best practice, it is advisible...

Parthi,

Use variables...here in this case:

1.)yourVariable=Name+time...i.e. the format you wish to save the name of the file

2.)you may use a FST(File System task to route and store your file in the...