Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
NalakaAFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:

>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that i
s
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>

Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
NalakaAFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:
>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that is
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>sql

Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
Nalaka
AFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/
|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:

>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that is
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>

HELP--SSIS Dataflow Task

Need help regarding ssis dataflow task

I need to create a ssis package. I want to import the data from a flat file to a table.

Lets say, the table has 5 columns -- col1, col2, col3, col4 , col5.(Assume that all columns can be NULLABLE) The datafile contains the data related to only three columns say col1, col2, col3. So when I use dataflow task to import the data from the file to the table, I will only get three columns, col1, col2, col3. Columns col4, col5 will be NULL.
However, I want to populate columns col4, col5 with some values which are stored in the variable.

IS there any way to do this?

Any help would be appreciated.

Thanks

vjai wrote:

Need help regarding ssis dataflow task

I need to create a ssis package. I want to import the data from a flat file to a table.

Lets say, the table has 5 columns -- col1, col2, col3, col4 , col5.(Assume that all columns can be NULLABLE) The datafile contains the data related to only three columns say col1, col2, col3. So when I use dataflow task to import the data from the file to the table, I will only get three columns, col1, col2, col3. Columns col4, col5 will be NULL.
However, I want to populate columns col4, col5 with some values which are stored in the variable.

IS there any way to do this?

Any help would be appreciated.

Thanks

What variable?

-Jamie

|||

Nullable flat file columns is a bit of a strange one, how do you tell the difference between null and an empty string? Having no column is not a valid way to represent null, that is an invalid file format! I suspect what you are asking cannot be done, certainly not if the format of the file changes.

if the format is static, but sometimes values are empty then you could use a Derived Column transform to test for this and substitute a variable value in place.

|||

hi Vijai

You can do this!! and its very simple

Steps

I assume that u have a source with 3 cols.

Now add a drived column transformation task create two new columns and in expression give corresponding variable .

Now if ur output will have 5 columns, 3 from ur source and 2 new columns having values from the variables.Do the necessary mapping with destination.

Thanks and Regards

Rahul Kumar, Software Engineer, India

HELP: Failed to create the task. (Microsoft Visual Studio)

I created my first SSIS project in BI Dev Studio but get the following error when trying to add a data flow task to the Control container:

==================================

Failed to create the task. (Microsoft Visual Studio)

===================================

Value does not fall within the expected range. (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Executables.Add(String moniker)
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

Any advice greatly appreciated..

cheers,
jordan

What build are you on? June CTP by chance?|||I just installed the June CPT and I am gettting this same error. Any ideas?

Thanks in advance.|||

Here's the entire error message:

===================================

Value does not fall within the expected range. (Microsoft.SqlServer.ManagedDTS)

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Executables.Add(String moniker)
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

|||Yes it is June CTP Developer Edition.|||I also couldn't use the SQL Server Import and Export Wizard. The error that I get:

The SSIS data flow task could not be created. Verify that DTSPipeline.dll is available and registered. The wizard cannot continue and it will terminate.

Value does not fall within the expected range. (Microsoft.SQLServer.DTSRuntimeWrap)|||Hmmm, very odd. It sounds as though you have a corrupted installation. Is this the first time you've installed SQL Server on that machine, IOW is it a clean install? You might try to regsvr32 DTSPipeline.dll. Then try again. It appears that it's just not registered.|||

I have tried uninstalling and reinstalling the CPT 4 times. The last time I did a regclean, deleted left over directories and anything else I could thing of the make the install clean.

One thing I should mention is that I had the VSS.Net 2005 Beta 2 on my machine before I installed the SQL Server 2005 CPT and I had to remove it in order to go forward with the SQL install. Not sure if that left something’s behind. I did use the SQL removal tools to get things off my machine the last couple of times, but not the first. The first time I used the Add/Remove Programs applet, and those uninstalls failed, but the option to remove through the applet disappeared afterward.

Very frustrating. I have installed this on another machine without the problems; it's just that that machine is not my main workstation (and not portable).

I will try the regsvr32 suggestion and regasm on some of the other libraries if that doesn't help.

Thanks!

|||Tried that, no luck.

Any other suggestions?

Thanks!|||I did a search on my local hard drives and couldn't even find DTSPipeline.dll. The CTP version that we have were downloaded from MSDN subscribers download web site.

cheers,
j.|||Has there been any resolve to this error at all? I am close to giving up on the CTP entirely.

Any help would be greatly appreciated.|||Where are you getting the install from? What SKU are you installing? The DtsPipeline.dll should be installed on all SKUs. Are you installing Integration Services? Is there a Microsoft SQL Server\90\DTS folder on your machine? What's in there?|||yeah there is indeed a C:\Program Files\Microsoft SQL Server\90\DTS\Binn directory with DTSPipeline.dll in there. But still re-registering the DLL did not help.|||What control container are you trying to add the dataflow task to?|||Control Flow. But as I mentioned in my earlier post I couldn't even get Import/Export wizard to work within Management Studio.