摘要：来自：http://www.cnblogs.com/sodacc/archive/2012/11/26/2789135.html第一次用SQL给SSIS包排JOB的时候，都会遇到这样一个问题：单独执行包的时候都成功了，但是放在JOB里执行的时候会报错，如果查看作业的历史记录的话，可看到大都是因为权限的问题，这个问题大致有几个解决方法，无非都是将配置写在包中，这样就不会出现用sql Agent代理账户读取时没有权限的问题了，现在给出一个我一直用的方式：1、将SSIS切换到控制流页签，右击属性，将ProtectionLevel 设置为EncryptSensitiveWithPassword，并在P 阅读全文

摘要：This information is from:http://blogs.msdn.com/b/dbrowne/archive/2010/07/08/how-to-configure-an-ssis-package-to-access-a-web-service-using-wcf.aspxWhen you are connecting to a web service from an SSIS Script component or transform using a WCF client, the normal method of configuring the WCF client f 阅读全文

摘要： 阅读全文

摘要：1. In Script Task componentSet Value:Dts.Variables["ErrorMsg"].Value = string.Format("Connection Config Exception:{0}", ex.Message);Dts.Variables["ErrorStatus"].Value = true;Get Value:string FileName = (string)Dts.Variables["FileName"].Value;2. Execute SQL Tas 阅读全文

摘要：Snapshot：When using the 'Flat File Source' and 'OLE DB Destination' or something else components to load some data through the components. Maybe we will have the error like that.Mismatched locale IDs. The component locale ID (2052) does not match the connection manager locale ID (205 阅读全文

摘要：Step 1:Step 2:Step 3： 阅读全文

摘要：Step 1: create a tableCREATE TABLE [EmployeeImported]([EmployeeID] [int] IDENTITY(1,1) NOT NULL,[ContactID] [int] NOT NULL,[ManagerID] [int] NULL,[Title] [varchar](100) NOT NULL,[MaritalStatus] [char](1) NOT NULL,[Gender] [char](1) NOT NULL,[HireDate] [datetime] NOT NULL) ON [PRIMARY]GOStep 2：open S 阅读全文

摘要：My target is using SSIS to export the data into Excel file from SQL Command(OLB DB Source).However. I created a very simple demo to testing the functionality as below(SQL query thing) but nothing can be export successful.declare @Temptabletable (Id int, Name nvarchar(50))insert into @Temptable value 阅读全文

摘要：When I using SSIS to export data from database.There are two exception was caught:The exception detail as below:SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.--Solution one--If you' 阅读全文