Thanks for your reply. I used oledb command task to call a proc for encrypting the data and store it in the table.

Hi,

I have created the certificate and symmetric key for encrypting a column(SSN column.)

1) I have to load the data from TXT file to a table named 'Emp' in SQL.

2) But...

Thanks a ton.I faced this issue today and I sorted out by seeing your screenshot..

So why is it saying 'Cannot open the data file" ?

Yes you are correct. I mentioned the path wrongly. It's only C:/

No folder.

I have deployed the package in my local file system and the file does exist.

Also the filename is stored in a variable and evaluated as expression:

Variable name ...

Hi All,

I have a SSIS package which get the result from a query and dumps that in a TXT file.

It runs well in BIDS. But when I scheduled this as...

i have around 140 packages 🙁

One more question:

if a package runs successfully i want to move that package from that path automatically or it may be renamed.By doing this i believe this would eliminate the...

Yes I can do that.But my concern is I am using "For Each loop" task for executing several child packages (Which makes million of rows to be loaded into the...

Hi,

Today I am facing problem when invoking multiple packages from a master package.

Here is the scenario.

Master Package has the below tasks conigured.

- For Each loop container (To loop through a...

Ok Got it.Thanks.

Below is the error message I am getting when I try to set up table valued package configuration.I am referring the same configuration filter across all the packages.Since the...

Below is the error message I am getting when I try to set up table valued package configuration.I am referring the same configuration filter across all the packages.Since the...

Jeff,

Yes the connection is named the same(Configuration filter is reused in each package) across all the packages.

I find the error when I click on Edit package configuration.