I'm not sure, will it work if you install VSTA in 2005, check below links pls

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/10343135-107f-4bb3-a2e3-b56e82c40fb8

and

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7c113172-4117-4b29-bcc2-4b56b60ed079

Theo...

Sounds good that you switched to .csv, if possible can you reply to my post, Just thinking what wud be the actual problem.

1. Are all the input files are having...

Please let us know if you need further help/info....:-)

RB

Pls check this link,

http://www.sqlservercentral.com/Forums/Topic946733-148-1.aspx

so set Run64BitRuntime = false of your project properties

RB

Convert into two text files using SSIS, then read data from script task and replace as you wanted and save to new file, long method but feasible.

RB

use 4 DFD's and enable the required DFD and disble the rest on the fly...

or use BCP as some one suggested in other thread....

RB

http://www.sqlservercentral.com/Forums/Topic944849-148-1.aspx

PHXHoward,

you can write Event Handlers, to do so...

Select Event Handler Tab in BIDS

Executable: from drop down select your package Name ( means defining event handler at package level)

Event Handler: Onerror...

Theo....

Pls refer the attached screen image, EXCEL uses 32 bit provider, so set Run64BitRuntime = false of your project properties,(not Solution) to run your package correctly.

and also note, you cant...

Reg : Moving file to another folder, you can do any of the following steps

1. simplest one, use execute process task,

set executable property as Move.exe / xcopy.exe /Copy.exe (Give...

List all a,b,c,d reason values in Parameter and select parameter value, include this value in report and thats it...

RB

Thank you,

I assumed that, he has two different queries running against two databases and need to output into single file ( not sure about the structure/Data types info etc)

RB

Simply, you can export into two flat files and then use execute process task to merge above two files

set below Execute process task properties

Executable : copy.exe

Arguments : target1.txt+target2.txt finaloutput.txt

regards

RB

Phani,

Please find the attachment, to run this, create some valid/invalid files and point to that folder before running.

Note, i have used activeX scrit task ( I have VSTA issue in...

Read the txt file contents in script task using system.io, then you can define precedence constraints.

RB