I have a table with values, col1col2col3 10ABA 10ABB 10ABC 20BBA 20BBB 20BBC I am trying to update the table to see the number of repetition of col1, in this case col1 has repeated 3 times so each
I am trying to write an Oracle query that has some variables set before the query which i can then reference within the query.
I\'m stuck on this one. I hope someone here has some experience with this. Here is the situation. I have set up a web page that allows users to upload flat files to be loaded into SQL Server 2005 usin
I tried the following code to import a string from XML <xs:element minOccurs=\"0\" name=\"FIELDNAME\" type=\"xs:string\" />
Running SQL Server 2008, in SSIS appending an * to the folder path got all the loose files, but doesn\'t move the subdirectories.I could set up a ftp create directory task and a ftp transfer task for
I have a SSIS package with approximately fifty data flows in it that interacts with an Oracle database.
I have a package which executes several tasks including a Bulk Insert Task. This is okay when run from Visual Studio. I have a console application which will run the same package but fails when doing
select FiscalMonthID = (select FiscalMonthID from CurrentFiscalMonth (nolock)), T.OrgKey, DataSourceKey = 26,
I\'m trying to use SQL Server 2008 SSIS to read an XML file and put it into a database, but I\'m having problems. Everything is green when I run debugging, but no data is actually transferred. Even wh
I should preface by saying my experience with scripting or programming in OOP languages is limited. I\'m working on a method for programatically creating and executing SSIS packages using PowerShell.
加载中,请稍侯......