Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

SSIS Conditional Flow?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Conditional Control Flow Element

A branching element is critical to any process flow. Currently, as far as I know, there;s only a Conditional Split Data Flow Element. There is no direct way I can branch out in a control flow.

In some cases, I could branch by using a conditional operator ?: to either create a dynamic sql string for each patch, or a package name for a Package Execution task and so on.

This approach is not always good enough.


Are there others out there who want a Conditional Control Flow element?


View Replies !   View Related
Conditional Execution In The Control Flow Via Script Task

I'm trying to conditionally execute a dataflow based on the presence of a data file. If the data file isn't present, I'd like to execute gracefully without error.

Logic is as follows:

If FileExists Then
  execute dataflow
  exit w/o error
End If

I've got the code ready to go, but I'm not sure how to do this conditional branch logic. Right now, the code calls the Dts.Results.Success / Failure.  The problem, however, is Failure is exactly that... which doesn't result in the graceful exit I'm looking for.

Anyone have any ideas?

Thanks in advance.

View Replies !   View Related
SSIS Variables Between Data Flow And Control Flow... How To????
Hi everyone,
Primary platform is 64 bit cluster.
How to move information allocated in SSIS variables from Data Flow to Control Flow layers??
We've got a SSIS package which load a value into a variable inside a Data Flow. Going back to Control Flow how could we retrive that value again????
Thanks in advance and regards,

View Replies !   View Related
How Can I Check Variables Comes From Data Flow In Predence Constraints And Conditional Transformation?

I have Variable , data source and conditional transformation which checks the count(*) if the count == 0 then I connect an script component and change variable to false(initial it is True) and write into a log file...
Then I check that variable on predence constarint at workflow if variable==True then success. BUT
Whenever I run the package my dataflow gets green even the condition does not meet like count==0 . So
my variable's value is "False". Actually if the condition doesnt meet then my script shouldnt work.
Am I missing something???

View Replies !   View Related
Conditional Checks In SSIS.
I have two connections in a package pointing to two different databases
on the same server. I have to insert records from 'DB1' table 'Gender1'
to 'DB2' table 'Gender2'. Before I do that though, I have to make sure
the minimum value (of all the Gender Keys that are going to be
inserted) of 'DB1' 'GenderKey' (which is an identity field) is greater than the
maximum value of DB2-GenderKey (which is a primary key but not an
identity field).  How can I do this simple check? I have to do this process for many different tables ....... Gender table is just an example. If someone can give an detailed explanation on which tasks to use and how to use them (as I am relatively new to SSIS) that'd be great.

View Replies !   View Related
Checking Conditional In SSIS
I am converting a DTS package to SSIS.


DTS has the following steps:

1. SQL task that returns a variable ( a count ).

2. ActiveX script:

Function Main()

If DTSGlobalVariables("gsPrevProcessCount").Value > 0 Then
   MsgBox "The data for one or more of your members has already been processed. Please review your data files and remove the processed files from the data directory."
   Main = DTSTaskExecResult_Failure
   Main = DTSTaskExecResult_Success
End If

End Function


In SSIS, I have an Execute SQL Task that returns a variable PrevProcessedCount. Now, I am stuck. How do I display a message to the user (or maybe just put it in the audit log) and how to I check the variable and stop processing my package?




View Replies !   View Related
SSIS- Doing Conditional Duplicate Removals

First post here. Anyway, I have a question regarding SSIS. I'm currently given a task that requires reading a flat file, applying duplicate removal as well as invalid data removal, processing it, and finally writing it to a SQL Server 2005 DB.
Part of the processing requires checking for partial duplicates in the batches of records provided in the text file. For example, the record contains a a phone number, status, timestamp of creation and various other entries. If a phone number is repeated (meaning, duplicate entry), a column called 'Status' must be checked, and only entries with the status of 'C' is allowed through.

Another part of the processing requires that if the phone number is repeated along with various other entries including status, the timestamp of creation is checked and only the entry with the most recent timestamp is accepted.
I would like to know how to implement this in SSIS without using table objects and scripts, as my experience tells me that doing this in a script can really take a hit on system performance. The task is expected to handle tens of thousands of records in a day.
Any help will be appriciated.

View Replies !   View Related
SSIS Conditional Column Mapping

I have a condition where if  column5 is equal to 1 then put column6 into the destination column "dest6", if it is not equal to 1 then put column6 in destination column "dest7"
What is the best way to do this in SSIS?
If I have to use the conditional split then do I have to copy my complete mappings, exact change this one column?
Thank for the help this mapping will take me a long time!

View Replies !   View Related
Conditional Insertion && Updation In Destination Table (SSIS)
    How to create package in SSIS by applying the business Logic like if the record already exist it should be and update else it should be an insert in the destination table. how to achive this funcality in SQL SERVER 2005 (Business Intelligence studion).

Thanks & Regards




View Replies !   View Related
How To Write Condition In The Conditional Split Control In SSIS
HI i need to write the Condition for Insert and Update Reccord depending upon the Prod_ID. How to write the Follwing condtion in the Condition Split? pls Anyone give me the Solution?


 "  if   Prod_ID  Exist then  UPDATE  Records

    if Prod_ID   Not EXIST then INSERT Records "


 how to write the above conditon in the Condional Split?

Thanks  &  Regards,





View Replies !   View Related
SSIS - Conditional Split, Date Compare Problem!! Please Help
Right the answer is probably simple but the Internet and books and everything has been no joy to me whatsoever.

I want to split my data stream based on the date. So I want to use a conditional split object to do this.

I entered the following as my case date_created > (DT_DBTIMESTAMP)"01/10/2000" 

When I move off the line it stays black so appears to be okay, yet when I run my package it says it is not a boolean result and fails. Can anyone please tell me what I am doing wrong.

Also I cannot filter in the source call due to the sheer amount of work being done on the data before the split.

Thanks in advance for any help

View Replies !   View Related
Help With SSIS Data Flow
To keep this simple, I have a control flow that loops through files in a folder. Within that loop I have a data flow. In my data flow I read in the file as a whole to get some counts of header rows, data rows, and total file size and store that in a db using various components. The last component in my data flow so far is a script component which I use to validate something so that I have set up 2 output paths, 1 if the validation passes and 1 if it errors out. For the error, I store the info in the db. For the row that passes, what I need to do is now go back to the origional file and instead of loading it as a whole, I need to now load it separating the data into columns. I cannot figure out how to do this. I was going to use another file source to reload but it will not let me connect the output of the script component to it. Does anyone have any ideas on how I can now go back to the orig file on disk and reload the data? or is there another suggestion?
 Thanks a bunch in advance!!!

View Replies !   View Related
Flow Control In SSIS
I am having a hard time with what appears to be something simple. I want to import an excel spreadsheet into a table on a daily basis from a command line. I created a package from the Import Wizzard in the SQL Management Studio and saved it. Since I want a clean table each day, my process needs to be create a temp table, import from the Excel file into the temp table. If that is successful, delete the original table and rename the temp table the original name. The point of this process is to provide for a fail-safe if there is some unforseen problem downloading the data on a particular day.
When I run the package, the first thing it does is delete the original table. I know this because the process shows the time that it finished is before anything else has started or finished. The time shown for the completion of the data flow task is about 2 minutes after that time.
This is maddening!!! The one thing I do not want to happen I can not seem to prevent. I have my control flow set on success. Why does it do this?

View Replies !   View Related
Cursor, Conditional Split Task, Nested Joins In SSIS

Can anybody help me out in
1) implementing cursors in SSIS. I want to process each row at a time from a dataset. I was trying to use Foreachloop container but in vain. Can you please answer in detail.
my few other questions are:
1) Can i do nested inner join in SSIS. If yes, how? ( I have three table i need to join Tab1 to table 2 and get join the table 3 to get the respective data)
2) I have a resultsets. I want to split the data according to data in a col.
Say for instance:
Col1 Col2
A        1
A         2
B        3
C        4
C         5
i want to split the data according A, B and C . i.e., if Col1= A then do this, if Col1= B then do this..etc. How can i do this using conditional split task in SSIS

View Replies !   View Related
Using Wild Card Filter Character In Conditional Splits In SSIS

I am using Conditinal split in my package. I need to remove certain rows which are matching my criteria. The criteria requires using wild card characters like, first_name = '%john%'.
How do I achieve this?
Please help

View Replies !   View Related
Execution Flow Of SSIS Package


I want to know detail execution flow of SSIS package (like Validation -> Expression evaluation -> Execution etc.)

Where can I get detail information, any reference (links)?

Thanks in advance.


View Replies !   View Related
SSIS Ate My Data Flow Task!
I was working all day making changes to my 3MB package. I was adding a large number of transforms that were copied-and-pasted from elsewhere in the same data flow task.
All was going well. I even took the time to have SSIS lay out the task again (1/2 hour). Suddenly I started receiving some strange errors:

After the layout, I noticed two stray components 'way off in the upper right corner. I found that one of them had a duplicate name to a component which had been added hours ago. Even after deleting it, I got "duplicate name" errors.

I copied three components in one selection, and when I tried to paste them, got the error "can't initialize component on paste". I tried them one at a time, but got the same error.

I got errors about COM failures due to marshalling to another thread
I then exited Visual Studio and started it again. To my great surprise, the data flow task I was working on was still there, but was completely empty.  
Comparing what I'm left with to my last version in source control, I find that the entire pipeline element is missing from the DTS: ObjectData element!
I'm developing a real love/hate relationship with SSIS. It varies from one day to the next. Guess what kind of day this is!

View Replies !   View Related
Xml Ssis Data Flow Component?
There is a table with a column that contains Xml documents. For each record from my Data Flow Source, I want to pass in the Xml document and the node to interrogate, and return the value contained in the node.  Like the Crm component, this is probably one I will have to write from scratch in C#, but I would like to avoid having to create the custom component if it already exists in the public arena. 


Does anyone know of any Xml Ssis Data Flow Components that are downloadable for free?

View Replies !   View Related
SSIS Data Flow Parameterize Query

I am using SSIS in SQL Server 2005 and want to have a query like this in my data flow task

Select a.*
from abc as a
inner join (Select max( as ID from xyz as b inner join pqr as c on = and > ?) as t1
on =

SSIS fails to detect the parameter (?) for the inner query and gives message.

Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable.", so assuming this is your problem, then you can workaround.


The idea is to parameterize the inner query ,,,
(so if the above query doesnt make sense ignore it )

View Replies !   View Related
SSIS Data Flow Batch Question
I am loading a lot of Excel and CSV files to SQL Server. Some loading may fail for various reasons. I want a file either be load as a whole or nothing. Currently I keep a list of failed filename and remove it at the end (I add a column for source file name).


Any better way to make sure a file is loaded as a whole or nothing?



View Replies !   View Related
SSIS Data Flow Task Is Hanging

I have a derived column works fine on following expression with a delimiter "~" in the string, but it hangs when the delimiter "~" is missing.

(DT_STR,15,1252)(FINDSTRING([Column 0],"~",1) == 0 ? (DT_STR,15,1252)NULL(DT_STR,15,1252) : (SUBSTRING([Column 0],1,(FINDSTRING([Column  0],"~",1) - 1) <= 15 ? (FINDSTRING([Column  0],"~",1) - 1) : 15)))

example data 1: "xxx~12/07/06 12:00PM~yyy", it works fine with the expression;

example data 2: "xxx   yyy", it causes expression hanging;

How can I fix my expression?



View Replies !   View Related
SSIS Data Flow Task Problem
Hi, there,

I am having some problems with the loading of tab delimited text file (source) to a SQL Server table (destination) using the SSIS data flow task. Package has been executed successfully with no error msg. The number of rows in the text file also matches the number of rows in the SQL table. But, when I check the content of the table, I noticed some of the columns contain NULL which supposed to have value. This happens not to all the rows but only to some rows. I did some testing by removing some rows from the beginning, middle and end of the text file and re-run the package but the result is quite inconsistent. Sometimes, the field got filled, but sometimes, it just contains NULL where it supposed to have value.

What will be the possible causes to this?

Thanks in advance.


Yong Hwee

View Replies !   View Related
SSIS DATA Flow Task Freezing

I am experiencing an error where the ssis data flow task would freeze and stop data export from a oledb source to a text file. It doesn't generate any errors the ssis package would just hang. This only happens when I run it in 64 bit mode. When I change the mode to 32 bit the ssis never freezes and runs fine. Has anyone experience this? Is there a fix so I can run my jobs in 64 bit mode?


View Replies !   View Related
SSIS Error With Data Flow Task
When I add a Data Flow Task to a package, save it and then close. When I open it again, I get 3 errors and the detail of the Data Flow Task is empty.

I had try to uninstall and install my SQL Server 2005, but the problem continues.
Can some one help me on this?
Sérgio Cardoso

View Replies !   View Related
How To Disconnect Data Flow's Components Using SSIS API?

I have a SSIS Package which I would like to modify using SSIS API. I need to put new component between some two existing data flow's components. During this process I need to disconnect two data flow's components using SSIS API. How can I do that?


View Replies !   View Related
SSIS Data Flow Script Compoment

Hi ,
Is there any option to use OLE DB Source in Script Component?

View Replies !   View Related
How To Use Same Variable Between The Control Flow Tasks In SSIS 2005?
I want to get the start time of data load and end time after data load and store it in a table  which has mapping_id , mapping_name,start_time,end_time.

 i use ActiveXScript task to get the start time before data load and store the mapping_id in a global variable,then data flow transformation occurs.

 i want to use a global variable to store the mapping id ,so that i can update the end time after data load with that to do this?

is there any other way, i can get the start and end time of data load (other than the logging information)?

View Replies !   View Related
SSIS Data Flow Task Execution Priority
I have a package that loads staging tables from an Oracle source DB.  In the data flow tab I have 30+ read table/write table task combinations.  When I run the package 3-4 of the read/write combos execute at a time.  What I'm trying to control is the priority order of the combo execution.  My goal is to minimize to total load time by having the larger table transfers run first and the smaller table transfers fill in until they are all complete.  Currently, the largest table (16 million) transfers last (because it was the last combo that I created?).




View Replies !   View Related
SSIS Unexpectedly Ends Data Flow Task
I have a package that has multiple data flow tasks


According to the precedence constraints all of the data flows should complete prior to a script task running.


Unfortunately one of the data flow tasks is getting about halfway through then the script task starts in VS2005 the task remains yellow and the subsequent tasks turn green once complete.


Is there a logical reason for this or is it a bug?


View Replies !   View Related
SSIS Data Flow Source Version Issue
I added a toolbox item for a SSIS data flow source component version 1 into the toolbox in studio.

Later, I upgraded the data flow source component to version 2 with publisher policy.

But when I drag the toolbox item from the toolbox into the designer in studio, an error happens.   

SSIS still looks for the data flow source version 1.

I have to delete the toolbox item and add it with version 2 again.

Is there a way to make the toolbox item created with earlier version work in SSIS?



View Replies !   View Related
SSIS Partition Processing Data Flow Item
Does anyone have a helpful link for using the partition processing data
flow task in SSIS?  I am trying to process a monthly partition
from within my package and am getting the following error:

Error: 0xC113000A Errors in the high-level relational engine. Pipeline
processing can only reference a single table in the data source view.

If anyone has used this before and could point me in the right direction, I would appreciate it.



View Replies !   View Related
Data Flow Source For MS Access In SSIS Package
Hi all...

I'm creating a SSIS in the designer view of SQL Server BI Dev. Studio (SQL Server 2005)

I need to import a whole table from MS Access into my local SQL Server.(this task will be performed weekly, so once working I'll schedule a job for it)

I've created a 'FILE' connection to MS Access in the 'Connection Managers'.

When I'm on the 'Data Flow' tab I can't find a Data Flow Item to use as a MS Access connection.
(available on the 'Data Flow Sources' are only: DataReader, Excel, Flat File, OLE DB, Raw File and XML Sources)

What am I doing wrong/missing?

Thanks for your help.

View Replies !   View Related
SSIS Data Flow Execution Monitoring And Logging
Has anyone come up/determined a generic way to capture and log indicative information within a data flow in SSIS - e.g., a number of rows selected from the source, transformed, rejected, loaded, various timestamps around these events, etc.? I am trying to avoid having to build a custom solution for each of the packages that I will have (of which there will be dozens).  Ideally, I'd like to have some sort of a generic component (such as a custom transformation) that will hide the implementation details and provide a generic interface to the package. 

It is not too difficult to achieve something similar on the control flow level, but once you get into data flows things get complicated.

Any ideas will be greatly appreciated.

View Replies !   View Related
Logging Data Flow Steps In SSIS Package

I am using the "SSIS Log Provider for SQL Server" to log events to a table for "OnError" and "OnPostExecute" events of a package. This works as expected and provides a nice clean output on the execution steps of the package.

I am curious as to why I do not see any detail for any/all tasks that fall under the "Data Flow" section of the package though. For instance, on my "Control Flow" tab, I added a "Data Flow" task that simply loads a few tables from a target to destination server. However, there is nothing shown in the logging output. Just that a Data Flow task was initiated. And when I'm configuring this logging under "SSIS-->Logging" in the checkbox area on the left, you cannot "drill into" data flow steps.

 Is there a reason why there is no detailed logging for Data Flow tasks? Would getting to that require me to create a custom log provider?

Thanks for the help.


View Replies !   View Related
SSIS Failure - Can Not Add A Row To The Data Flow Task Buffer
I have a relatively simple SSIS package that I'm building for a data mining process.  The package starts with an OLE DB data source, passes the results of a SQL Command (query) along to a conversion step, which then gets sent to a Term Lookup task.  The Term Lookup then writes the result to an OLE DB Data Destination.  Pretty simple.  The OLE DB data source query returns about 80,000 rows if you run it through SQL WB.  The SSIS editor shows 9,557 rows make it out of the source, and into the conversion step, 9,557 make it out of the conversion and into the lookup, and about 60,000 rows make it out of the lookup and are written to the results table.  Then the package fails with the following errors listed on the progress screen.  I was assuming that the 9,557 was some type of batching that was occurring in the process, but now I'm not so sure. 



[DTS.Pipeline] Error: The ProcessInput method on component "My Component" (117) failed with error code 0xC02090E5. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC02090E5.
[DTS.Pipeline] Error: Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
[DTS.Pipeline] Error: Thread "WorkThread1" has exited with error code 0xC0047039.
[My Data Source  Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
[DTS.Pipeline] Error: The PrimeOutput method on component "My Component" (1) returned error code 0xC02020C4.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.

View Replies !   View Related
Little Urgent.....Advice On Logic Flow In SSIS Transformation......!
Dear All,
I have a table A with a KEY column and SSN column.
KEY = 12 digits ( first 3 digits are Department Id , and last 9 digits are SSN)
I have a table B with SSN column only.
both KEY and SSN columns are Primary keys so duplicate entries must be Avoided.
Table A is intended to be popluated weekly from TXT file (SSIS package RUN). I want to achieve somethign like this..!
P-Code sample:
for each Row in TXT file
              if TXTfile.KEY = TableA.KEY then
                     skip and Read/Go to next Row in TXT file
                  INSERT TXTfile.KEY into TABLEA.KEY
                  SSN_Var = EXTRACT the SSN part (SSNpart.READ)
                             if SSN_VAR.Exists In TableB.AnyRow then
                                 Insert into TableB
                             End If.
               End If
End For Loop.
Using SSIS controls, what will be best flow and logic to achieve this.....?
any sample scripting code ????
Many Thanks.

View Replies !   View Related
SQL 2005 SP2 - Cannot Open Data Flow Task In SSIS
I have just installed Service Pack 2 on my SQL 2005 Standard Edition.

However, now all my SSIS packages will not allow me to open my Data FLow Tasks.  I get the following error:


TITLE: Microsoft Visual Studio


Cannot show the editor for this task.



The task returned an unsupported control editor type. (Microsoft.DataTransformationServices.Design)


If I try to create a new Data Flow task I get:


TITLE: Microsoft Visual Studio


Failed to create the task.



The designer could not be initialized. (Microsoft.DataTransformationServices.Design)


I have tried to install the latest hotfixes after this but they had no effect.

Can anybody help me???? Please?



View Replies !   View Related
Multiple Execution Paths In SSIS Control Flow
Hello all,


Is there documentation somewhere about multiple execution paths in SSIS control flow? I didn't find documentation anywhere. I have a situation where I have two tasks that take considerable time, but could be executed in parallel (to speed up things) and I was wondering whether SSIS supports parallelism.


To illustrate the issues in simultaneous execution, I created a test SSIS package. In the package, I have five tasks, let's call them T1, T2, T3, T4 and T5. The taks are connected with "green arrows" like this:







T5 is not connected. The tasks can be e.g. Send Mail tasks, that's not relevant to this issue. I put a breakpoint in each task and execute the package.


When I execute package, T1 and T5 become active, i.e. the arrow that displays where the package execution currently is, is in two tasks simultaneously. Now F10 (step over) doesn't seem to work "Unable to step. Not implemented". If I press F5 nothing happens. After I press F5 for a second time tasks T1 and T5 and executed. Why don't they execute with the first pressing of F5? I would additionally like to know whether these two tasks are executed in parallel or sequentially, i.e. in the same thread or in two threads? Is there documentation of this?


The execution stops at T2&T3. Again, pressing F5 doesn't do anything, but the second time I press F5 T2 and T3 are executed.




View Replies !   View Related
SSIS Sequence Container,data Flow Task
I am creating a staging database in which I am loading required tables from 2 different sources.
I have 30 different tables to load from source 1 and 10 different tables from source 2.
This is the way I am doing, in Control flow task I am using Sequence container and in that I included the data flow task, the data flow task
has source OLD DB connection from where I select the table and then destination OLE DB connection where I load the data.
So for 30 tables I have one Sequence container with 30 different data flow task and each data flow task has OLE DB source and OLD DB destination.
I wanted to find out if this is the efficient way to do, or if there is any other way to do this.
And for source 2 shall I put in another package or shall I use the same package with different sequence container and follow the same steps
as for Source 1 tables.
Please advice.

View Replies !   View Related
SSIS Upward Precedence Execution Flow Issues
I'm building a package wherein I perform a SQL task(A) if the error log is not empty. This same SQL task(A) is also being used by another data flow task(B). The precedence points from B to A bottom to top. When I execute, all the tasks in the downward direction (precedence pointing downward/sideways) execute but this one doesnt as it points updwards.  I can copy and paste task A and make B point to A downward, but I dont want to duplicate A in the same package.
Is there any other approach?
If you dont understand the above, see the flow:
   X (SQL task) ----on success-------------> A (SQL task)
   |                                                             ^
   |                                                             |
    ...(sequence of steps)                              | 
   |                                                             |
   |                                                             |
   B(Data Flow Task) ---------failure --------|
Execution flow doesnt move from B to A, even though its a failure condition. Hope this explains the problem.
Thanks and Regards,
Subha Fernando

View Replies !   View Related
Custom SSIS Control Flow Task Implemented In C++
Hi Guys,

This is a question to the SSIS development team. I would like to know what are the requirements to implement custom SSIS Control Flow task in C++ . There is a documentation describing the process when implementing a managed task, but no such documentation exists for implementing a task in C++.

Thank you,

View Replies !   View Related
Logging Data Flow Component Events In SSIS
Does anyone know how to hook up to data flow pipeline events via custom solution (C#)? I am trying to write code to log start and end times of components(lookup,merge joins etc) in a data flow task. I tried with a class inheriting from the EventsProvider class but it didn't work as this is only for container tasks. Any ideas will be greatly appreciated.

View Replies !   View Related
SSIS Programming Setting Name To Data Flow Component
I am creating a SSIS Programmatically. I facing problem in setting name to data flow compenent.
here is the sample code

IDTSComponentMetaData90 oledbItemMasterSource;

oledbItemMasterSource = dataFlow.ComponentMetaDataCollection.New();

oledbItemMasterSource.ComponentClassID = "DTSAdapter.OLEDBSource";

oledbItemMasterSource.Name = "InventTable";

oledbItemMasterSource.Description = "Get Item Master";

After creating this package i found that 'InventTable" is not set to OLE Db Source component. where as i can set name to OLE DB Flat File destination component.
Kindly suggest me a way fix this issue.

View Replies !   View Related
Do We Have IF-ELSE Construct Similar To A Flow Chart Execution In SSIS?

Hi All,
           Just needed an insight into the IF-ELSE construct w.r.t its implementation in SSIS or a similar methodology that could be adopted in SSIS while executing a Package.
Scenario : I want to Start with importing data from Different sources to SQL Server Destination. For Which, i define 3 different Data Flow Tasks each involved in importing data from an external source to SQL Server Destination.
1] Text File Inbound Task : Source - Flat File Source ; Destination - SQL Server Dest.
2] Excel Inbound Task : Source - Excel Data Source ; Destination - SQL Server Dest.
3] Xml Inbound Task : Source - XML Data Source ; Destination - SQL Server Dest
Finally i want to execute the package with an IF-ELSE Scenario which will Check for the external Source being :
IF External Source = = Excel file  => Execute Excel Inbound Task

IF External Source = = Text File/Flat File = > Execute Text File Inbound Task
IF External Source = = Xml File => Execute Xml Inbound Task


View Replies !   View Related
Multiple Data Flow Tasks In One SSIS Package
What are the advantages and disadvantages of having multiple data flow tasks in one SSIS package?


Is this a good idea at all considering the workflow may be similar now but may change in the future? Should it be left as one data flow per package?

View Replies !   View Related
Create A Data Flow In SSIS Wich Updates Som Rows.

I have a table customer wich has the columns phone_number(char type) and ok_to_call(bit type). There are already data in the table and the column ok_to_call only contains the value false for every row.

Now i want to update the latter column. I have a text file with a list of phone numbers and i want that all the rows in the Customer table(phone_number column)that matches the number in the text file to update ok_to_call to true.

This is to be done in SSIS(Integration Services). I'm new at this and i've looked around that tool but is a lot of items, packages and stuff so i dont know where to begin.

Would appreciate help on how to solve this issue in SSIS. What controlflow/Data flows to use,wich items and packages to use, how to configure and how to link together?


View Replies !   View Related
SSIS Data Flow Task Slows During Bulk Insert
I have an SSIS Package which is designed to import log files.  Basically, it loops through a directory, parses text from the log files, and dumps it to the database.  The issue I'm having is not with the package reading the files, but when it attempts to write the information to the db.  What I'm seeing is that it will hit a file, read 3000 some lines, convert them (using the Data Conversion component), and then "hang" when it tries to write it to the db.


I've run the SQL Server Profiler, and had originally thought that the issue had to do with the collation.  I was seeing every char column with the word "collate" next to it.  On the other hand, while looking at  the Windows performance monitor, I see that the disk queue is maxed at 100% for about a minute after importing just one log file.


I'm not sure if this is due to the size of the db, and having to update a clustered index, or not.


The machine where this is all taking place has 2 arrays- both RAID 10.  Each array is 600 GB, and consists of 8 disks.  The SSIS package is being executed locally using BIDS.


Your help is appreciated!



View Replies !   View Related
How Can I Append Children To Parents In A SSIS Data Flow Task?
I need to extract data to send to an external agency in their supplied format.  The data is normalised in our system in a one to many relationship.  The external agency needs it denormalised. 


In our system, the parent p has p_id, p_attribute_1, p_attribute_2, p_attribute_3 and the child has c_id, c_attribute_a, c_attribute_b, c_parent_id_fk


The external agency can only use a delimited file looking like

p_id, p_attribute_1, p_attribute_2, p_attribute_3, c1_attribute_a, c1_attribute_b, c2_attribute_a, c2_attribute_b, ...., cn_attribute_a, cn_attribute_b


where n is the number of children a parent may have.  Each parent can have 0 or more children - typically between 1 and 20.


How can I achieve this using SSIS?  In the past I have used custom built VB apps with the ADO SHAPE command but this is not ideal as I have to rebuild each time to alter the selection criteria and and VB is not a good SQL tool. 

View Replies !   View Related

Copyright © 2005-08, All rights reserved