Hi Phil, thanks for your answer.

I stilll have one question:

-Can I avoid the use of Dynamic SQL using a stored procedure?

I have read about "Table-Valued Parameters" and stored procedures and...

Hi Phil thanks for your answer.

Now I'm trying to persuade my colleagues to go directly to the database and not over the web service. They allege that write directly is...

Hi,

Just Googling a Little bit:

Creating SSIS Project with Sybase IQ 15.2 using OLEDB Connection

Please tell us if that works.

Kind Regards,

Hi Trond,

thanks for your suggestion. I installed the extension modules for PowerShell and they seem to be a great option not only for SSIS package management.

There are always disadvantages, like...

Hi Sasidhar,

Just another question: It is possible to deploy the SSIS packages in different folders in the msdb.

I create a specific structure of sub folders in the msdb to organize...

Hi kd11,

You can import the package from the server to a file using the dtutil utility.

Example1:

dtutil /SQL srcPackage /COPY FILE;c:\myTestPackages\mynewpackage.dtsx

Of course you can run this command direct from the command...

Hi Sasidhar,

Thanks for your comment. I didn't know that this deployment utility exist. It would have saved me a lot of time.

I will try it.

Just one thing. I...

Hi opc.three

Thanks for your useful answer.

I did something similar. Just what you said, the only difference is I didn’t create an environment variable to point to the xml file. At...

Hi Phil,

It was a language mistake due to my level of English, which sometimes is not good enough 😀

You are right; the correct term is “temporary”

Thanks for your remark.

Hi Phil,

Thanks for your quick answer.

Then I will create a temporal table to store the records to be update, and then perform a batch or bulk update, I think it...

Hi Akshay,

I wouldn't use a OLE DB Command, it is extremly slow for large datasets. It will perform the updates row by row. It is a good exercise for...

Hi Akshay,

I just wrote an example of the usage of the Merge command in this post

I think the T-SQL merge command is a powerful option.

If you have any question I...

Hi Rocky´s

I totally agree with that, the use of the merge command is for me the better option. I designed several ETL packages the last year and I tried the...

Hi Daniel,

The problem here is how to look up the Audit_Id in your Audit table using one or more columns from your dimension or fact tables. You have the following...

Hi Obiron,

Thanks for your comment!

It is a linked server in my Management Studio.

The customer did exactly what you said. All of the fields are at the end Strings. I discovered...