Hi,

Have you used the OnError event under the Configure SSIS Logging dialog or the OnError even under the Event Handlers tab in the designer. On the later you can do...

Can't you do what you need by setting the precedence on the control flow?

Hi,

In your SP you print @cmd to the console. Have you tried copying and pasting this into a command window?

Also you could try using DTExecUI.exe to generate the command line...

Hi,

This sounds like it is realted to the package protection level. Check this out.

http://support.microsoft.com/kb/918760

Regards

Daniel

The first one is how many rows to skip from the top, the second is how many to skip after the header rows i.e. the data rows

Hi,

This is likely to be down to the ProtectionLevel property on your package. This might help or give you a better understanding of how the package security works.

http://support.microsoft.com/kb/918760

Regards

Daniel

Hi,

I can't find a way of making SSIS object to not finding configuration file which is surprising.

You could do something like following in a script task when using an...

Hi,

Have you tried to ftp a file to the fileserver from the server on which the DTS runs from using another ftp client. ie ftp from a command prompt.

This shows...

Hi,

You could do this via a script task though I think you might need excel installed on the server. Check this out.

http://www.microsoft.com/technet/scriptcenter/resources/officetips/mar05/tips0308.mspx

Regards

Daniel

Hi,

The foreach loop doesn't need to know the meta data for each file. The meta data you are describing is defined within the data source connection. You need to use...

Hi,

I got this to work. The most important step is to set the BypassPrepare option on the SQL Task to true else I get he error you described above.

Is this...

Hi,

I'm pretty sure you can't delete data from an excel spreadsheet using OLEBD. However a simple way to do this would be to have an empty copy of the spreadsheet...

Hi,

Have you checked the flat file connection configuration for your column. Edit your flat file connection and then look under the Advanced table at the column definitions. Check that your...

This had me quite baffled for a while but I think and hope I have found the solution to this problem. Though I don't the exact technical details I am...

Hi,

I've not tried this on a stand alone SSIS installation yet but you should be able to execute the packages from the file system using the DTExec.exe utility. There is...