Thanks for response. Can you please provide me any code or syntax that imports csv/txt file into SQL CE without SSIS/DTS.

In other words, can we run ssis package without sql server attached?

Is there a utility or exe that can run dtsx package on a pc?

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...

Can you pls provide some insight about your task.eg...what kind of file you reading?what kind of output you generating?

You can define cr/lf delimiter for getting data in rows. As far as columns are concerned, you can use substring function of sql to create and fill columns. eg: if...

My suggestion for you is to define username and password in connection string rather than username and pwd field.

I think you can use dstrun.exe to execute the package. Since its an exe, u don't need to install it on client/destination pc.