I\'m currently building an ETL system to load a data warehouse from a transactional system. The grain of my fact table is the transaction level. In order to ensure I don\'t load duplicate rows I\'ve p
Is there any way i can trim the blank spaces when I read data from CSV file? Thank开发者_StackOverflow社区s.The SendMail task requires \';\' between email ids.If you are building one large string to
My send mail task works fine for email ids like user@mydomain.com but it throws error for email ids like user@subdo开发者_Python百科main.mydomain.com.
In SSMS I\'ve gotten my for xml path query written and it\'s beautiful. I put it in an \"Execute SQL Task\" in the Control Flow, set the result开发者_StackOverflowset to XML.
We have eight Xeon (i7) cores and 16 gig of RAM on our SSIS box.We have about 200 image files we want to convert using a command line utility every day.Currently the process is using Adobe Photoshop a
I want to add an email notification to an SSIS 2005 package event handler.I\'ve add开发者_JAVA百科ed a Send Mail task to the event handler.I\'d like to customize the email body to include things like
Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn\'t complete properly (no error messages though).
I am using SSIS Dataflow to import data into SQL2008. My data source is an excel file. The dataflow is working, however it seems that it is importing开发者_JAVA百科 empty rows from the Excel file.I
I\'m running a fairly substantial SSIS package against SQL 2008 - and I\'m getting the same results both in my dev environment (Win7-x64 + SQL-x64-Developer)and the production environment (Server 2008
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely solicit debate, a
加载中,请稍侯......