September 15, 2008 at 6:40 pm
Hi
I have a package which reads a flat text file(file A), does data validation and filteration and spits out an excel tab delimited file(File B). This output file(File B) goes into a VB application as input.
Issue: I want to automate the process where I just click a button and File A is picked up--->transformed into File B and fed into VB application.
Constraint: It has to run on local PC which does not has SQL Server Installed.
Note: VB application can be run thru .exe or MSI.
September 16, 2008 at 12:33 am
Don't have an SSIS package at all. Do all validation and stuff in a windows application.
OR
Have your client windows application call a service (web or wcf) on a sql server box to run the package and put the file where you tell it to. Then the windows app can pick up the file and do whatever.
September 16, 2008 at 12:43 am
Currently I am trying to use sequence container for complete process.
Seq of Execution is :
1)Run Import process(File A).
2)Run Data validation process.(Creates File B) and copy to a destination for VB application.
3)Process Task to install the VB.net application.
4)Process task to execute the VB app with File B for input which produces File C.
I want to use DTEXEC to run the package without sql installation as DTEXEC is an EXE file so I can simply copy and put it in a folder .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply