Showing posts with label load. Show all posts
Showing posts with label load. Show all posts

Monday, March 19, 2012

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 variable.how to do this?

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

Using an execute SQL task you can do this. One before the data load, and one after.

In the first, you can use System:: StartTime. In the second you can use getdate().

In the first, you'd have to map the parameter, in the second you just use getdate() in the SQL.|||How do you get the mapping id? If you have the mapping id you could use a number of Execute SQL Task shapes in the control flow to update the start and end times at the relevant step.

Greg.

|||What is the mapping_id?

How To use OLE Control like MS Access on SQL Server

I need some help to use an OLE Control which found in MS Access, to save and load files directly .
so Is there any way to implement [OLE] Control with SQL SERVER vs .NET such as VB NEt or C#..
thank youany help please|||how I need a help quickly|||

Quote:

Originally Posted by jooorj

I need some help to use an OLE Control which found in MS Access, to save and load files directly .
so Is there any way to implement [OLE] Control with SQL SERVER vs .NET such as VB NEt or C#..
thank you


No there is no way to do that. You need to use a compiling language.

Monday, March 12, 2012

How to use MSDE to link data in Access

I have data in Access mdb file. I wish to link or load data into MSDE 2000.
How to do it ?
I believe there is an "Upgrade Wizard" inside Access that will do that for
you.
Dennis
"hkappleorange" <hkappleorange@.yahoo.com.hk> wrote in message
news:%23CDjN2Z4FHA.252@.TK2MSFTNGP15.phx.gbl...
>I have data in Access mdb file. I wish to link or load data into MSDE 2000.
> How to do it ?
>