I have created a functioning SSIS package which pulls rows from a flat file into a SQL table. I just need to be able to delete old rows in the table, once they are older than 10 days.
Got it working - Posted My solution below but will like to know if there is better way Hello All I am trying to create Domain Event for a newly created (after migration) domain object in my database
I need to create an SSIS package for importing data from multiple Excel files into an SQL database. I plan on using nested Foreach Loop containers to achieve this. One Foreach File Enumerator and nest
I have created a basic Data Flow tasks in SSIS 2008 t开发者_如何学JAVAhat is reading information from a a basic text file and importing it into a database. The file is Delimited with lines ending with
Hi all i have been struggling this for a while now! I have some data files with a date in them, these are dumped into a staging table. What i would like my script/function to do is to re开发者_JAVA百科
Im getting a \"An error occurred while attempting to perform a type cast\" when using a derived column to format some error information.My Expression is a follows
Way back in 2000, I did some ETL development with SQL Server DTS packages. I started out using the designer to create the packages but then eventually settled with using the SQLDMO (Database Mgt Objec
I have a few SSIS 开发者_高级运维packages that are built in VS2008 I am trying to set up to run on a schedule with the SQL Server Agent. I am having trouble figuring out how to deploy these. I can run
I have a datasource whose output is connected to a Script Component. When i add some columns to the datasource. I should go to S开发者_如何学Gocript component and check the newly added columns as inpu
I have the following piece of SQL that will check if any duplicate records exist. How can I check to see if no records 开发者_开发百科are returned? I\'m using this in an SSIS package. I only want it t
加载中,请稍侯......