I have a package in which I need to load a flat file to a staging table, then perform an upsert to a production table. Actually, this has to happen a number of times for different files with different
I\'ve exported records to a flat file delimited by \"|\" and it seems that when I import those records into a new database , SQL Server treats the NULL values as empty fields. IMy queries worked 开发者
I have a SSIS package contai开发者_运维技巧ning an error variable that I would like to email out, but only if it is not blank (no errors).So, I put the constraint @[User::PackageError] != \"\" between
We are using SSIS to transfer the contents of 3 tables from ServerA to ServerB ServerA is located inhouse, ServerB is in a datacenter.
I am executing SSIS packages from an application server that is different than the database server.This package will be reading and writing files.Is it better to have the potentially large input files
I have a stored procedure i want to ru开发者_如何转开发n which will returna 0 or a 1.I would like to store that value in a ssis variable
I would like to be able to run a SQL task that runs a stored proc.The proc returns 0 or 1.If it r开发者_如何转开发eturns 1 then email.Store the execution result from the stored procedure in a variable
I\'m importing data from Oracle to SQL Server 2005 using SSIS. I think the datetime fields in Oracle are stored to a higher precision than SQL Server 2005 \"DATETIME\" fields will allow, causing overf
I am tansfering data from MSSQL to MySQL using SSIS.I have done mapping of all the tables.But while executing the package I am getting errors :
When using SSIS in SQL Server 2005 to convert a FoxPro database to a SQL Server database, if the given FoxPro database has a date type, SSIS assumes it is an integer type. The only way to convert it t
加载中,请稍侯......