ssis

相关标签：javascript jquery android 多少钱 iPhone

How to delete SQL rows based on source file last modified date, using SSIS package?

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.[详细]

2023-04-04 19:20 分类：问答
SSIS Scripting Component: Get child records for creating Object

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[详细]

2023-04-04 19:11 分类：问答
How to loop through Excel files and load them into a database using SSIS package?

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[详细]

2023-04-04 13:16 分类：问答
Why is SSIS OLE DB Import Not Importing Last Line of a text File?

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[详细]

2023-04-04 09:45 分类：问答
Dynamic Table Insert TSQL

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百科[详细]

2023-04-04 07:38 分类：问答
SSIS casting error

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[详细]

2023-04-04 05:47 分类：问答
SSIS Recommended Practices for handling "bad" data

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[详细]

2023-04-04 02:29 分类：问答
How do I deploy an SSIS package to run on a schedule as an SQL Server Agent job?

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[详细]

2023-04-03 13:23 分类：问答
Automatically Adding Columns to an SSIS Script Component

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[详细]

2023-04-03 10:13 分类：问答
How to proceed to the next task only if no records exist for a given query?

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[详细]

2023-04-02 12:35 分类：问答