If you want to load all the excel files in a directory, you just need folder location and files(*.xls). You don't have to use variables for these. Inside you can...

Its not clear(Going to its location ???), how r u executing exactly and when r u getting this error ?

-V

Hi,

You need to work around with something like this....Find all command options available through winzip..It has password (-s) command etc...You need to use xp_cmdshell, unless you are not fan of...

Hi,

You need to deploy your package. How did you copy the package to msdb folder ? Refer the SSIS package deployment..

-V

hi,

You have to use script task to check for null and replace it with ""

Try this:

If Row.Column1_IsNull = True Then

Trim(Row.Column1) = ""

...

I guess it is the problem with the network so the communication error.

-V

Hi,

Yeah..Begin and end..Also, It didn't like database name with the disable trigger..I had 39 triggers to disable..

Solved...

Thanks Guys!!!

You forgot to put the code...

-V

Hi,

How to find triggers assosiated with a table ?

Thanks again..

-V

Hi,

I wanted to know disable all triggers at once, which had text like GLPAudit, not individually. Using dynamic sql it may be possible I guess..But I don't know much dynamic...

Hi,

You cn usev execute sql task to use t-sql. In your case, you have to use variables to map your stored proc opuput. even you can use t-sql on job...

Hi,

It is not clear that you have problem with restoring of your msdb database or with the SSIS package inside msdb database. If you wnt to access SSIS package in...

Hi,

Do you have sufficient permission to use sql server agent ?

Thank you for your answers. I will try, any way its a brand new server !!!

-V

Do you have BIDS installed ?

-V