EXtract data from 10 identical oracle database into one

Please guide me urgently how to extract data in SSIS from 10 identical oracle database into 1 sql server database.

There is a table which list all the 10 databases.

You could do it all in one data flow task or many it's up to you. Basically, you'll need to create a connection manager for oracle and one for sql server. For the source define the table or query to extract the needed data from orcale and then connect it to the destination. Then just map the columns from source to target.

|||

JIGJAN wrote:

Please guide me urgently how to extract data in SSIS from 10 identical oracle database into 1 sql server database.

There is a table which list all the 10 databases.

You can use a For Each loop to drive this process. Put an Execute SQL to retrieve the list of databases, and connect it to a For Each loop set to enumerate a rowset. In the For Each loop map a variable to the database name. Put an expression on the connection manager for the Oracle database, to create the connect string dynamically. Put a data flow (or multiple flows, depending on the number of tables) inside it, configured to copy the tables.

Extra column in destination

I have worked with straight-forward simplistic SSIS up to now, so I apologize if this is a simple question. I have a SQL table destination that accepts daily data from an AS400 table. We now have a need to datestamp the incoming data so I added a new column to the destination table where I want today's date. Is there a data flow transformation that I need to use to default the destination column to today's date? Time is not a consideration and not needed, just the date.

Thanks for the information.

Use a derived column transformation and inside add a new column using "getdate()" as the expression.|||Thanks again for the help!|||

guyinkalamazoo3 wrote:

Thanks again for the help!

Yep, no problem. There are a whole host of other dates available for your use as well, if you look in the system variables list. System::ContainerStartTime, etc...

Extra column in destination

I have worked with straight-forward simplistic SSIS up to now, so I apologize if this is a simple question. I have a SQL table destination that accepts daily data from an AS400 table. We now have a need to datestamp the incoming data so I added a new column to the destination table where I want today's date. Is there a data flow transformation that I need to use to default the destination column to today's date? Time is not a consideration and not needed, just the date.

Thanks for the information.

Use a derived column transformation and inside add a new column using "getdate()" as the expression.|||Thanks again for the help!|||

guyinkalamazoo3 wrote:

Thanks again for the help!

Yep, no problem. There are a whole host of other dates available for your use as well, if you look in the system variables list. System::ContainerStartTime, etc...sql

extending SSIS Container?

Has anyone investigated extending any of the SSIS Container classes?

I have been looking into it because we'd like to add a set of standard logging calls on events, standard startup procedures, etc. on any package that we execute.

I've been looking into the Sequence Container, For-Each, etc. They are all sealed classes. I'm not sure why MS has sealed them.

We're currently thinking of implementing our own version of the Sequence Container -- we'd really like to be able to extend the functionality of a standard container class, but we don't want to have to implement the actual container class itself.

Any insight appreciated.

Nope, it is not possible to extend these classes.

The managed classes in Dts.Runtime namespace allow you to manipulate the built-in containers in a package. They are sealed because they are not actually used at execution time, so subclassing them would not be useful.|||

Thanks Michael.

I'm not sure I understand how the containers are not used at execution time -- something like a For-Each loop container would be, wouldn't it?

I think what I'd really like to do is extend the SSIS Package class instead. But that is sealed as well. Perhaps we'll wind up using something like a decorator for the Package class.

|||When package schedules the tasks, SSIS uses its internal representation for For-Each container, but not the actual .NET class. I.e. even if you could subclass the container and override Execute() method, SSIS would not call your method.

We've received similar feedback several times. For now, you can use Execute Package task to achieve some of the functionality, but we know it does not provide all the functionality that might be needed.|||

jhikel wrote:

Has anyone investigated extending any of the SSIS Container classes?

I have been looking into it because we'd like to add a set of standard logging calls on events, standard startup procedures, etc. on any package that we execute.

I've been looking into the Sequence Container, For-Each, etc. They are all sealed classes. I'm not sure why MS has sealed them.

We're currently thinking of implementing our own version of the Sequence Container -- we'd really like to be able to extend the functionality of a standard container class, but we don't want to have to implement the actual container class itself.

Any insight appreciated.

frequently used logging configurations can be created as templates.sql

Extending native components

Can anyone provide any direction in extending existing SSIS components with a custom component, if it's possible at all. In some cases there are just slight bits of functionality missing that I think I could add in myself. But, I'm not much of a programmer and need a bit of help in the declaration of the component in my own custom component.

Thanks.I don't beleive this is possible. Whilst I am looking at the managed interfaces, not native code, they are all documented as sealed or not inheritable.

Extending BI studio

Hi,
I need to add a custom menu option say under the Tools menu in the BI studio for SSIS projects. Is it possible to extend BU studio using Visual studio addins, or Visual Studio SDK (VSIP).

The Visual studio addin works fine; however I want my custom menu option to show up only when I have a SSIS project open so that I can perfom my custom step whenever the user selects the menu option

Thanks,
-SuriYou can extend BIDS with standard Visual Studio 2005 add-ins, because it is Visual Studio 2005. If you look at the Help menu, About, you will see it is the full VS IDE. The "Installed Products" list just shows different items depending on if you have installed through SQL Server tools only, VS only, or both SQL & VS together.|||Hi Darren,
The real problem I am facing is that the Visual Studio 2005 addin wizard allows you to specify the contextGUIDS which are defined in the vsContextGuids class. This class has guids defined only for Visual Basic, C# and J# type projects. I am not sure how I can specify a SSIS project using the vsContextGuids class.

-Suri|||Sorry, haven't got that far myself yet, but I look forward to someone else answering as I'm sure I'll need to know.

Just out of interest what does your SSIS specific add-in do?|||In the custom action, I need to load the package, parse it for some specific information, and write that information to a xml file (basically filtered package information) which can be then read and processed by another app we have.

Thanks|||

I'm not positive if this is what you're after, but I have an SSIS deployment add-in that we use to allow developers to deploy packages to a server. We use the following code to determine what packages are in the current solution, it may help? This sample builds nodes on a treeview for each project/package found in the current solution.

Private Const ssisProjectKind As String = "{d183a3d8-5fd8-494b-b014-37f57b35e655}"

If _applicationObject.Solution.Count = 0 Then
Return "Not valid without an open solution"
End If

Dim prjCount As Integer = 0
Dim pkgCount As Integer = 0

For Each proj As Project In _applicationObject.Solution.Projects
If Not proj.Kind = ssisProjectKind Then
Continue For
End If
prjCount += 1
Dim prjNode As TreeNode = Me.tvPackages.Nodes.Add(proj.Name)
For Each pi As ProjectItem In proj.ProjectItems
If pi.Name.EndsWith(".dtsx") Then
Dim pkgNode As TreeNode = prjNode.Nodes.Add(pi.Name)
pkgNode.Tag = pi.FileNames(0)
pkgCount += 1
End If
Next
Next

If prjCount = 0 Then
Return "No SSIS Projects were found in this solution"
End If

If pkgCount = 0 Then
Return "No SSIS Packages were found in this solution"
End If

Thanks!
Harry

Extending BI studio

Hi,
I need to add a custom menu option say under the Tools menu in the BI studio for SSIS projects. Is it possible to extend BU studio using Visual studio addins, or Visual Studio SDK (VSIP).

The Visual studio addin works fine; however I want my custom menu option to show up only when I have a SSIS project open so that I can perfom my custom step whenever the user selects the menu option

Thanks,
-SuriYou can extend BIDS with standard Visual Studio 2005 add-ins, because it is Visual Studio 2005. If you look at the Help menu, About, you will see it is the full VS IDE. The "Installed Products" list just shows different items depending on if you have installed through SQL Server tools only, VS only, or both SQL & VS together.|||Hi Darren,
The real problem I am facing is that the Visual Studio 2005 addin wizard allows you to specify the contextGUIDS which are defined in the vsContextGuids class. This class has guids defined only for Visual Basic, C# and J# type projects. I am not sure how I can specify a SSIS project using the vsContextGuids class.

-Suri
|||Sorry, haven't got that far myself yet, but I look forward to someone else answering as I'm sure I'll need to know.

Just out of interest what does your SSIS specific add-in do?|||In the custom action, I need to load the package, parse it for some specific information, and write that information to a xml file (basically filtered package information) which can be then read and processed by another app we have.

Thanks
|||

I'm not positive if this is what you're after, but I have an SSIS deployment add-in that we use to allow developers to deploy packages to a server. We use the following code to determine what packages are in the current solution, it may help? This sample builds nodes on a treeview for each project/package found in the current solution.

Private Const ssisProjectKind As String = "{d183a3d8-5fd8-494b-b014-37f57b35e655}"

If _applicationObject.Solution.Count = 0 Then
Return "Not valid without an open solution"
End If

Dim prjCount As Integer = 0
Dim pkgCount As Integer = 0

For Each proj As Project In _applicationObject.Solution.Projects
If Not proj.Kind = ssisProjectKind Then
Continue For
End If
prjCount += 1
Dim prjNode As TreeNode = Me.tvPackages.Nodes.Add(proj.Name)
For Each pi As ProjectItem In proj.ProjectItems
If pi.Name.EndsWith(".dtsx") Then
Dim pkgNode As TreeNode = prjNode.Nodes.Add(pi.Name)
pkgNode.Tag = pi.FileNames(0)
pkgCount += 1
End If
Next
Next

If prjCount = 0 Then
Return "No SSIS Projects were found in this solution"
End If

If pkgCount = 0 Then
Return "No SSIS Packages were found in this solution"
End If

Thanks!
Harry

Expressions not always evaluated in correct order

Hello!

I have an SSIS package, run by the DTExec utility, each night. When I run my package, I assign a value to a variable (package scope) (/SET "\Package.Variables[User:: psRunNo]";0154). (Note: all the variables here are strings).

Value for variable psRunNo = 0154

In the package, I have another package variable called S_SOURCE_FILE_NAME, which is an expression and that uses the variable psRunNo.

Expression for S_SOURCE_FILE_NAME = @.[User:: psRunNo] + "_{TABLENAME}.txt"

So, at the beginning, the value of variable S_SOURCE_FILE_NAME is 0154_{TABLENAME}.txt with that example.

Then, I use the variable S_SOURCE_FILE_NAME in the expression used to assign the ConnectionString property of a Connection (a source file), like this:

REPLACE( @.[User:: S_REJECTED_ROWS_FILE_NAME] ,"{TABLENAME}", "STADDRES")

So here for example, the final value for ConnectionString would be 0154_STADDRES.txt

Everything works nice, most of the time. Sometimes (intermittent problem), the value of the ConnectionString for one of the many Connections I have in the package is not assigned with the right value of psRunNo. The ConnectionString gets the value of psRunNo which is saved into the package (when it was deployed) instead of the value of psRunNo passed with the DTExec.

It is like if the ConnectionString value was computed before the variable psRunNo (and S_SOURCE_FILE_NAME expression) was assigned to the new value, but only for one of the connections (all my connections use the same kind of expression for their ConnectionString property).

Does somebody had similar precedence problem? Is there some settings I could use to indicate a precedence in assignation of variables ? Where does the "natural" precedence in assignation comes from in SSIS ?

Thanks!

Isabelle_ wrote:

Does somebody had similar precedence problem? Is there some settings I could use to indicate a precedence in assignation of variables ? Where does the "natural" precedence in assignation comes from in SSIS ?

Thanks!

There isn't really a precedence. If VariableC depends on VariableB which depends on VariableA then all will get evaluated when VariableC gets used somewhere. The expressions are not pre-evaluated or anything like that.

This doesn't help explain the problem you are seeing. I confess I can't undersand why it might be happening. Can you post a repro?

-Jamie

|||

I could not post a reproduction as is, because even if I would make up a small package with my case, this case is intermittent, so almost impossible to get it right... I was thinking maybe on making a script at the beginning of my package and "manually" assign the variable values, instead of using expressions.. Normally, the outcome would be the same, but maybe that would ensure that those variables always get their right values before being use... ?

|||

Isabelle_ wrote:

I could not post a reproduction as is, because even if I would make up a small package with my case, this case is intermittent, so almost impossible to get it right... I was thinking maybe on making a script at the beginning of my package and "manually" assign the variable values, instead of using expressions.. Normally, the outcome would be the same, but maybe that would ensure that those variables always get their right values before being use... ?

You could try that but this is just papering over the cracks. Something else is wrong here. Could it be that you haven't got EvaluateAsExpression=TRUE?

-Jamie

|||

I've check, and I got the EvaluateAsExpression=TRUE. I guess also that if I wouldn't have it to true, it would never work. But it works, 90% of the time ...

Ok, thanks anyway. I've changed my thing so I just have one level of expression. I will let it run for few days/weeks and see if this problem still happen.

Thanks everybody for your input!

Expressions not always evaluated in correct order

Hello!

I have an SSIS package, run by the DTExec utility, each night. When I run my package, I assign a value to a variable (package scope) (/SET "\Package.Variables[User:: psRunNo]";0154). (Note: all the variables here are strings).

Value for variable psRunNo = 0154

In the package, I have another package variable called S_SOURCE_FILE_NAME, which is an expression and that uses the variable psRunNo.

Expression for S_SOURCE_FILE_NAME = @.[User:: psRunNo] + "_{TABLENAME}.txt"

So, at the beginning, the value of variable S_SOURCE_FILE_NAME is 0154_{TABLENAME}.txt with that example.

Then, I use the variable S_SOURCE_FILE_NAME in the expression used to assign the ConnectionString property of a Connection (a source file), like this:

REPLACE( @.[User:: S_REJECTED_ROWS_FILE_NAME] ,"{TABLENAME}", "STADDRES")

So here for example, the final value for ConnectionString would be 0154_STADDRES.txt

Everything works nice, most of the time. Sometimes (intermittent problem), the value of the ConnectionString for one of the many Connections I have in the package is not assigned with the right value of psRunNo. The ConnectionString gets the value of psRunNo which is saved into the package (when it was deployed) instead of the value of psRunNo passed with the DTExec.

It is like if the ConnectionString value was computed before the variable psRunNo (and S_SOURCE_FILE_NAME expression) was assigned to the new value, but only for one of the connections (all my connections use the same kind of expression for their ConnectionString property).

Does somebody had similar precedence problem? Is there some settings I could use to indicate a precedence in assignation of variables ? Where does the "natural" precedence in assignation comes from in SSIS ?

Thanks!

Isabelle_ wrote:

Does somebody had similar precedence problem? Is there some settings I could use to indicate a precedence in assignation of variables ? Where does the "natural" precedence in assignation comes from in SSIS ?

Thanks!

There isn't really a precedence. If VariableC depends on VariableB which depends on VariableA then all will get evaluated when VariableC gets used somewhere. The expressions are not pre-evaluated or anything like that.

This doesn't help explain the problem you are seeing. I confess I can't undersand why it might be happening. Can you post a repro?

-Jamie

|||

I could not post a reproduction as is, because even if I would make up a small package with my case, this case is intermittent, so almost impossible to get it right... I was thinking maybe on making a script at the beginning of my package and "manually" assign the variable values, instead of using expressions.. Normally, the outcome would be the same, but maybe that would ensure that those variables always get their right values before being use... ?

|||

Isabelle_ wrote:

I could not post a reproduction as is, because even if I would make up a small package with my case, this case is intermittent, so almost impossible to get it right... I was thinking maybe on making a script at the beginning of my package and "manually" assign the variable values, instead of using expressions.. Normally, the outcome would be the same, but maybe that would ensure that those variables always get their right values before being use... ?

You could try that but this is just papering over the cracks. Something else is wrong here. Could it be that you haven't got EvaluateAsExpression=TRUE?

-Jamie

|||

I've check, and I got the EvaluateAsExpression=TRUE. I guess also that if I wouldn't have it to true, it would never work. But it works, 90% of the time ...

Ok, thanks anyway. I've changed my thing so I just have one level of expression. I will let it run for few days/weeks and see if this problem still happen.

Thanks everybody for your input!

Expressions not always evaluated in correct order

Hello!

I have an SSIS package, run by the DTExec utility, each night. When I run my package, I assign a value to a variable (package scope) (/SET "\Package.Variables[User:: psRunNo]";0154). (Note: all the variables here are strings).

Value for variable psRunNo = 0154

In the package, I have another package variable called S_SOURCE_FILE_NAME, which is an expression and that uses the variable psRunNo.

Expression for S_SOURCE_FILE_NAME = @.[User:: psRunNo] + "_{TABLENAME}.txt"

So, at the beginning, the value of variable S_SOURCE_FILE_NAME is 0154_{TABLENAME}.txt with that example.

Then, I use the variable S_SOURCE_FILE_NAME in the expression used to assign the ConnectionString property of a Connection (a source file), like this:

REPLACE( @.[User:: S_REJECTED_ROWS_FILE_NAME] ,"{TABLENAME}", "STADDRES")

So here for example, the final value for ConnectionString would be 0154_STADDRES.txt

Everything works nice, most of the time. Sometimes (intermittent problem), the value of the ConnectionString for one of the many Connections I have in the package is not assigned with the right value of psRunNo. The ConnectionString gets the value of psRunNo which is saved into the package (when it was deployed) instead of the value of psRunNo passed with the DTExec.

It is like if the ConnectionString value was computed before the variable psRunNo (and S_SOURCE_FILE_NAME expression) was assigned to the new value, but only for one of the connections (all my connections use the same kind of expression for their ConnectionString property).

Does somebody had similar precedence problem? Is there some settings I could use to indicate a precedence in assignation of variables ? Where does the "natural" precedence in assignation comes from in SSIS ?

Thanks!

Isabelle_ wrote:

Does somebody had similar precedence problem? Is there some settings I could use to indicate a precedence in assignation of variables ? Where does the "natural" precedence in assignation comes from in SSIS ?

Thanks!

There isn't really a precedence. If VariableC depends on VariableB which depends on VariableA then all will get evaluated when VariableC gets used somewhere. The expressions are not pre-evaluated or anything like that.

This doesn't help explain the problem you are seeing. I confess I can't undersand why it might be happening. Can you post a repro?

-Jamie

|||

I could not post a reproduction as is, because even if I would make up a small package with my case, this case is intermittent, so almost impossible to get it right... I was thinking maybe on making a script at the beginning of my package and "manually" assign the variable values, instead of using expressions.. Normally, the outcome would be the same, but maybe that would ensure that those variables always get their right values before being use... ?

|||

Isabelle_ wrote:

I could not post a reproduction as is, because even if I would make up a small package with my case, this case is intermittent, so almost impossible to get it right... I was thinking maybe on making a script at the beginning of my package and "manually" assign the variable values, instead of using expressions.. Normally, the outcome would be the same, but maybe that would ensure that those variables always get their right values before being use... ?

You could try that but this is just papering over the cracks. Something else is wrong here. Could it be that you haven't got EvaluateAsExpression=TRUE?

-Jamie

|||

I've check, and I got the EvaluateAsExpression=TRUE. I guess also that if I wouldn't have it to true, it would never work. But it works, 90% of the time ...

Ok, thanks anyway. I've changed my thing so I just have one level of expression. I will let it run for few days/weeks and see if this problem still happen.

Thanks everybody for your input!

Expressions and Datareader Source

Greetings my SSIS friends,

Apologies for asking a similar question again but I am still non the wiser with this problem!

Let me explain to you my situation and the method I've adopted to try and solve it.

I have some source data residing in a SQL Server 6.5 database. The source data consists of a single table. For this example I will assume that my table contains only 2 columns, an ID column called result_ID and a Result_Name.

The idea is to retrieve new data each time the package is run. We will know this because the result_IDs in the source table will be greater than the maximum result_ID in my destination table . The way the package should work is like this :

1) Retrieve maximum result_ID from destination table

2) retrieve data from source table where result_ID > maximum result_ID from destination table.

My package consists of a

1) SQL Query Task which retrieves the maximum result_ID and places it in a user variable (type Int32).

2) A Data flow task with a Datareader source adapter which uses an expression to retrieve the data. My expression looks like this : "select * from result where result_id > " + (dt_str, 10, 1252) @.[User::max_result_id]

When I run my package the first time all the rows are retrieved (as my destination table is empty to begin with). BUT when I run it the second time the same thing happens again!! All rows are retrieved.

I placed a breakpoint at the point where the variable gets populated with the maximum result_ID and true enough, the variable gets populated with the correct result_ID BUT then that variable gets reset to 0 in my expression!

This problem is driving me crazy! Has anybody out there experienced this kind of problem before?! What are the ways to solve it?!

Thanks for your help in advance.

What is the scope of the variable, User::max_result_id?|||

The scpe of my variable is Package so my data flow component shouldn't have a problem accessing it surely.

|||

Phil,

I have just read an interesting article by Kirk Haselden about Variables and their scope and I have now solved my problem! It turns out that I had another variable with a lower scope but with the same name and that was set to 0. In other words my Package level variable was working until SSIS got to the second variable and used that one instead.

I am officially an idiot today.

|||Glad you got it.

expression

Hi,

In ssis I would like to map a column from table a to a column in table b

Currently this is how I am doing it using sql.

I believe I have to use a derived column but not sure how to implement if statement inside it.

Thanks

case

when len([Column 5]) = 0 then ''

when lower([Column 5]) = 'unknown' then ''

when isdate([Column 5]) = 1 then substring(ltrim([Column 5]), 1, 4) + substring(ltrim([Column 5]), 6, 2) + substring(ltrim([Column 5]), 9, 2)

else

null

end,

Why not just leave it as is and use the SQL you've already got written?

The big problem is that there is no "isdate" function in the SSIS derived column transformation. So you'll end up writing a script to do that, which isn't hard, but if you're going to write the code anyway, you might as well just keep what you've got already in place.|||

Yes you are right but I am trying to learn how to use if inside the expression when mapping fields.

For example I can map two fields to each other but not sure how to include the if statement for that particular mapping. Thanks

|||

arkiboys wrote:

Yes you are right but I am trying to learn how to use if inside the expression when mapping fields.

For example I can map two fields to each other but not sure how to include the if statement for that particular mapping. Thanks

If ... else in an expression looks like this:

(condition to evaluate) ? true : false

So you might have:

(1 + 1) == 2 ? "YES" : "NO" - which will return "YES" obviously

In your example, without the "isdate" test:

LEN([Column 5]) == 0 ? '' : LOWER([Column 5]) == 'unknown' ? '' : etc....

Express ... DTS or SSIS

Chris Marsh wrote:
> Is there a download or way that DTS or SSIS can work with SQL Express 2005
.
> I need to import data at a client site on a live database.
> Thanks
http://msdn2.microsoft.com/en-us/library/ms143706.aspxThanks Tracy however I am confused about something after reading the KB you
pointed me to. It states "The Import and Export Utility that is included
with SQL Server 2005 Express Edition is not the SQL Server Import and Export
Wizard". So, where do I find the Import Export Utility to see if it will
resolve my needs? I just don't see it anywhere.
Again, thank you.
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150207527.154929.271070@.u72g2000cwu.googlegroups.com...
> Chris Marsh wrote:
>
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
>|||Chris Marsh wrote:
> Thanks Tracy however I am confused about something after reading the KB yo
u
> pointed me to. It states "The Import and Export Utility that is included
> with SQL Server 2005 Express Edition is not the SQL Server Import and Expo
rt
> Wizard". So, where do I find the Import Export Utility to see if it will
> resolve my needs? I just don't see it anywhere.
> Again, thank you.
Sorry, I don't have Express installed anywhere. I did search Google
for "sqlserver express import", and turned up lots of stuff. You might
find something useful there.|||Thanks...I'm blind I just cannot find it
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150212092.326676.276420@.f6g2000cwb.googlegroups.com...
> Chris Marsh wrote:
> Sorry, I don't have Express installed anywhere. I did search Google
> for "sqlserver express import", and turned up lots of stuff. You might
> find something useful there.
>|||Is there a download or way that DTS or SSIS can work with SQL Express 2005.
I need to import data at a client site on a live database.
Thanks|||Chris Marsh wrote:
> Is there a download or way that DTS or SSIS can work with SQL Express 2005
.
> I need to import data at a client site on a live database.
> Thanks
http://msdn2.microsoft.com/en-us/library/ms143706.aspx|||Thanks Tracy however I am confused about something after reading the KB you
pointed me to. It states "The Import and Export Utility that is included
with SQL Server 2005 Express Edition is not the SQL Server Import and Export
Wizard". So, where do I find the Import Export Utility to see if it will
resolve my needs? I just don't see it anywhere.
Again, thank you.
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150207527.154929.271070@.u72g2000cwu.googlegroups.com...
> Chris Marsh wrote:
>
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
>|||Chris Marsh wrote:
> Thanks Tracy however I am confused about something after reading the KB yo
u
> pointed me to. It states "The Import and Export Utility that is included
> with SQL Server 2005 Express Edition is not the SQL Server Import and Expo
rt
> Wizard". So, where do I find the Import Export Utility to see if it will
> resolve my needs? I just don't see it anywhere.
> Again, thank you.
Sorry, I don't have Express installed anywhere. I did search Google
for "sqlserver express import", and turned up lots of stuff. You might
find something useful there.|||Thanks...I'm blind I just cannot find it
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150212092.326676.276420@.f6g2000cwb.googlegroups.com...
> Chris Marsh wrote:
> Sorry, I don't have Express installed anywhere. I did search Google
> for "sqlserver express import", and turned up lots of stuff. You might
> find something useful there.
>

Express ... DTS or SSIS

Is there a download or way that DTS or SSIS can work with SQL Express 2005.
I need to import data at a client site on a live database.
ThanksChris Marsh wrote:
> Is there a download or way that DTS or SSIS can work with SQL Express 2005.
> I need to import data at a client site on a live database.
> Thanks
http://msdn2.microsoft.com/en-us/library/ms143706.aspx|||Thanks Tracy however I am confused about something after reading the KB you
pointed me to. It states "The Import and Export Utility that is included
with SQL Server 2005 Express Edition is not the SQL Server Import and Export
Wizard". So, where do I find the Import Export Utility to see if it will
resolve my needs? I just don't see it anywhere.
Again, thank you.
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150207527.154929.271070@.u72g2000cwu.googlegroups.com...
> Chris Marsh wrote:
>> Is there a download or way that DTS or SSIS can work with SQL Express
>> 2005.
>> I need to import data at a client site on a live database.
>> Thanks
>
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
>|||Chris Marsh wrote:
> Thanks Tracy however I am confused about something after reading the KB you
> pointed me to. It states "The Import and Export Utility that is included
> with SQL Server 2005 Express Edition is not the SQL Server Import and Export
> Wizard". So, where do I find the Import Export Utility to see if it will
> resolve my needs? I just don't see it anywhere.
> Again, thank you.
Sorry, I don't have Express installed anywhere. I did search Google
for "sqlserver express import", and turned up lots of stuff. You might
find something useful there.|||Thanks...I'm blind I just cannot find it:(
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150212092.326676.276420@.f6g2000cwb.googlegroups.com...
> Chris Marsh wrote:
>> Thanks Tracy however I am confused about something after reading the KB
>> you
>> pointed me to. It states "The Import and Export Utility that is included
>> with SQL Server 2005 Express Edition is not the SQL Server Import and
>> Export
>> Wizard". So, where do I find the Import Export Utility to see if it will
>> resolve my needs? I just don't see it anywhere.
>> Again, thank you.
> Sorry, I don't have Express installed anywhere. I did search Google
> for "sqlserver express import", and turned up lots of stuff. You might
> find something useful there.
>