I have a SSIS package which executes on several environment开发者_如何学JAVAs. On a specific server, the package freezes randomly during the cleanup of a dataflow. It happens randomly, and not every t
I have a [SQL 2008] SSIS package that takes a CSV text file and moves it to a separate folder.Once it is in this folder, I import the data to SQL.The text file is being automatically generated by an o
I have an XML source.. I can not seem to get the root attributes to be available.I have three other sections (elements) which all show as available.. it odes not seem to provide the root attributes.Ha
I havean ssis package...which read data from fixed-column-width text file into DB table. And I am modifying an existing ssis package.
I have created an SSIS package that will be deployed to client SQL installations (2005, 2008 or 2008 R2) to perform data extracts which provide a support tool for our product. The deployment process r
I have a flatfile...and have a SQLSErver table. I need to copy the data from flatfile to table. The flat file has 10 columns...I am able to copy all 10 columns.
Ok - this is probably a silly question but what the hell. I\'ve created a SSIS package with configuration and a deployment manifest. When I copied this over to the server and double clicked it, the P
I have created a SQL Server 08 database maintenance plan using the Wizard. The job shows in the msdb.sysjobs table but it doesn\'t show the schedule in the msdb.sysjobschedules table because the Wiza
Exploring the feasibility of something here... We have a UI page in the mvc3 web-application that the admin will use to upload a \'csv\' file. Is it possible to have an SSIS package that will be calle
Select Distinct REPLACE(REPLACE(REPLACE(REPLACE(Category, \' & \', \'-\'), \'/\', \'-\'), \', \', \'-\'), \' \', \'-\') AS Department
加载中,请稍侯......