Hi I am a newbie in SSIS. I wrote a sample package in which I configured a Data Flow Task something like shown below
I have a SQL Server Agent Job that previously had two steps.Today, I\'ve had to integrate the third step, and soon I\'ll need to integrate a fourth.
I apologize that this is a dumb question, but I have been pulling my hair out on it all day. We are running SSIS, and I need to make a tiny modification to the qu开发者_开发技巧ery. However, I have n
I have an Excel like this regionstatecity开发者_运维百科 ------------------------- southstate1city1
Folks, please excuse my lack of knowledge in this area, it\'s something I\'ve been tasked with fixing, but haven\'t had much luck with..
I have an SSIS package that the first task e开发者_运维知识库xecutes a stored procedure to verify that the run date is not a holiday.If it is a holiday, then it returns a record set with a count of 1.
We have a script task that processes a flatflat, inserts data into the database, then records any duplicates (via a stored proccedure) into a SQL table, which then passes it to a work flow task that l
I created a Windows Service that executes a SSIS Package every five minutes.It works pretty well, but something is tripping it up.
I did a proof of concept for a complex transformation in SSIS. I have performance metrics now for this POC that I created in a virtual machine, with 1 gig memory, 1 core assigned. The SSIS transfo开发
I have a very simple SSIS package where开发者_Python百科 I take data from a view in Oracle, minimally transform it with a script component, and load that into a table in SQL Server 2008.