Hi All,

I have done this before. The concept is simple, Load the flat file in ragged right format into a table with one filed having n/varchar(max).

Once its a table, we...

Hi,

No coding effort is required for posting SSRS reports to SharePoint. There is a subscription server available in SSRS, which you can schedule to generate and deliver a report...

Hi,

You have to setup a proxy account (using admin credentials) to run SSIS package from Sql Agent. Refer this article for further information on Proxy account.

You can't use proxy account...

Hi,

1. You should have BIDS/Sql Server Data tools installed in your machine to open the package in Execute Package Utility.

2. From Execute Package utility, you should be able to change...

Hi Ankit,

This is a well known error. If Flat file source can't read a file due to delimiter or text qualifier issues, definitely the source component will fail and the...

Hi,

What version of Sql server are you using?

Sql server 2005 - 2012 support image of size 2,147,483,647 bytes.

ntext, text, and image data types will be removed in a future version...

Hi,

Could you try to debug and see what integer value you get in flags for PASSWD_CANT_CHANGE. Also, try to declare int32 instead of int.

Regards,

Vijay

Hi,

Could you please explain the issue bit more on the package deployment. Which server is it deployed? is the same server where environment variable are available? I suggest to check...