I need to profile reference fields in a database to understand the patterns they are composed of. This needs to be done at a character level as there will be no spaces or punctuation in the reference
I\'m facing a problem when I deploy a DTSX File to a production server. In the DTSX file I consume a WebService through the Web Service Task,
I have created a process where a (registered) user can upload (after client-side and server-side validation) a (zipped with a very uncommon extension) access database to my ser开发者_高级运维ver throu
I am using the SSIS For开发者_JS百科each Loop Container to iterate through files with a certain pattern on a network share.
I use a lookup componen开发者_运维问答t. When No Match output, I insert the rows into a target table. I would like to update the target table with this rows when Lookup is matched.
When I try to execute a package which uses the Scripting Component object I get the following error: Error: 2011-07-22 09:16:42.25
I have sample table with columns: ID(guid)NameCreatedDate B27EB95B-B219-46BD-9E72-A378B3E7FED0A2005-11-20 22:49:46.000
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form. For help clari
I need to create a Console application that can copy a table from one remote sql server instance to another remote sql server instance.
My current scenario is that I have HQ pushing changes to branches. There\'s around 170 branches. The staging table that I\'m working with is used to prepare the data from HQ into rows that can be inse