I don\'t know if this will help, but i enabled logging to a text file called test.txt on my C Drive. Public Sub Main()
I am testing SSIS packages and stored procedures as I am only a beginner. What I need to do is use a stored procedure i have installed on a source database to return a dataset and then I need an ssis
I have 2 SQL Servers. ServerA and ServerB They both have a table called \"OrderRequest\" ServerA is \"in house\" and ServerB is in our datacenter.
I need to produce a Hash value based off of a variable length string that I can store within a field no longer than 16 (due to vendor requirements).
I have got a table containing rows of related data which I need to transform within an SSIS package and I am not sure how to go about it.
I currently have 2 stored procedures ... Stored Proc #1 returns a list of products based on a range of criteria
I\'m using dtexec to run an SSIS package from the command line. According to this page: http://msdn.microsoft.com/en-us/library/ms162810.aspx I should be able to change the location that the package l
basically I have 2 Db\'s to do a basic hello world example to get my head around stored procedures and SSIS in MS Server 2005.
I got a stored procedure, which gives me data by a dynamic pivot a开发者_JAVA技巧nd I want to insert this data into a table, which has all possible columns, the dynamic pivot could produce.
I am trying to figure out the best way to a开发者_开发百科pproach the following scenario. Overview