ssis
SSIS parent doesn't need password but child packages do - how do I get this to run in SQL server Agent?
I have a parent package that simply calls 4 child packages. All of these (parent and child) packages have been saved with package passwords. However only 2 of these child packages have non-sql connect[详细]
2023-04-02 07:12 分类:问答How do I call functions from C dll from SSIS ? or, how to load a C dll to GAc
I am creating a custom DTS Pipeline component for SSIS. This component calls a C# dll which is a wrapper around a C dll. Basically the C# wrapper defines the C dll functions\' 开发者_C百科signatures a[详细]
2023-04-02 06:52 分类:问答How to download file from website url using SSIS package
I want to download some files from Website URL using SSIS package or c# code But the problem is that website is buildup using flash and i need to login first then only[详细]
2023-04-02 05:22 分类:问答SSIS Script transformation error using ADO.NET
I\'m getting an error that states Incorrect syntax near \')\'. when executing my SSIS package. The error is being thrown by a Script transformation component in the DFT. From what I can tell it is bei[详细]
2023-04-02 01:15 分类:问答SSIS delete folders named with a date
My process ceates automatically some new folders named with a date i.e (09-01-2011) in a directory (Archive)[详细]
2023-04-01 19:33 分类:问答How do I make part of the text bold in a cell for an SSIS report?
I have a business requirement to make part of the text f开发者_运维技巧or a cell to be bold.It is an SSIS package that is an Excel report.I don\'t want to use COM or load Excel.How do I do that?As far[详细]
2023-04-01 19:28 分类:问答SSIS 2008 best way to run sequential packages
At this point,I created several packages that need now to be run sequentially at the end. How to do that?[详细]
2023-04-01 18:23 分类:问答SSIS 2008 error with Script task
Here is the code I write in my script task but I get the error , Name \'DTS\' is not declared 1)Any idea, how to resolve it?[详细]
2023-04-01 17:54 分类:问答T-SQL: is there a way to force conformance to ANSI SQL?
We are planning on writing a load process that uses SSIS and loads a SQL 2008 database. Transformations may be done in the packages or in stored procedures that are called from a package or directly f[详细]
2023-04-01 16:49 分类:问答Ignore records with null field when copying from one table to another using SSIS
Is it possible in a SSIS to ignore records that have a null field? For example i want to copy data from one database table to another, however Table A has some rubbish data in it and ha开发者_JAVA百科[详细]
2023-04-01 15:22 分类:问答