SSIS And Time With Milliseconds

May 22, 2007

I've been working on a project to ensure that accross our entire data warehouse everything is at the same accuracy level as far as time - migrating everything to use the full hh:mis.mmm. Some places were using hh:mis:mmm (colon instead of decimal point) and many places not using milliseconds.



The SQL server portion went essentially without issue - however SSIS is not cooperating. For example I have data I am importing from a file that is in format: hh:mis (no milliseconds) that I need to compare to data from SQL (now containing full milliseconds) - matching on time ranges. Previously this was done by converting both to the "database time" datatype in SSIS and comparing. Now when converting the cTime to database time SSIS fails and complains "The value could not be converted because of a potential loss of data".



I don't want to lop off the milliseconds becuase that could create rounding errors.



I don't like it but the only option I can think of is keeping everything in string and comparing the strings... then I run into the issue of making sure to convert all sources of data into the exact same hh:mis:mmm format in text.



Is there an easier way? I know some people use "milliseconds since midnight" and so forth but that would require major reworking of the data warehouse and many packages.

View 7 Replies


ADVERTISEMENT

Adding Milliseconds To Time

Nov 19, 2004

Hi,
i am trying to add milliseconds to a time. For example if i have a time of 01:01:05:000 and i want to add 0.297 milliseconds to it i use the following simplified query


SELECT CONVERT(nvarchar(20), DATEADD(ms, 0.297, '00:01:05:000'), 14) AS Expr1


However instead of getting 01:01:05:0.297 i get 01:01:05:000. Can somebody please tell me what i am doing wrong.

Thanks in advance.

View 4 Replies View Related

Adding Milliseconds To Time

Nov 19, 2004

Hi,
i am trying to add milliseconds to a time. For example if i have a time of 01:01:05:000 and i want to add 0.297 milliseconds to it i use the following simplified query


Code:


SELECT CONVERT(nvarchar(20), DATEADD(ms, 0.297, '00:01:05:000'), 14) AS Expr1



However instead of getting 01:01:05:0.297 i get 01:01:05:000. Can somebody please tell me what i am doing wrong.

Thanks in advance.

View 2 Replies View Related

Transact SQL :: Lockout Time In Milliseconds

Dec 1, 2015

why does select @@lock_timeout return -1. Shouldn't this return lock timeout in milliseconds?

View 2 Replies View Related

Set A Variable To Datetime And Time To Exact Milliseconds In SQL Server In Stored Procedure AS A Single String

Nov 1, 2007

I need to set a variable to datetime and time to exact milliseconds in SQL server in stored procedure.
 
Example:
set  MyUniqueNumber = 20071101190708733
ie. MyUniqueNumber contains yyyymmddhhminsecms
 
Please help, i tried  the following:
1. SELECT CURRENT_TIMESTAMP; ////// shows up with - & : , I want single string as in above example.2.
select cast(datepart(YYYY,getdate()) as varchar(4))+cast(datepart(mm,getdate()) as char(2))+convert(varchar(2),datepart(dd,getdate()),101 )+cast(datepart(hh,getdate()) as char(2))+cast(datepart(mi,getdate()) as char(2))+cast(datepart(ss,getdate()) as char(2))+cast(datepart(ms,getdate()) as char(4))
 
This one doesnot display day correctly, it should show 01 but shows 1
 
 
 
 

View 2 Replies View Related

SSIS Deriving Dt_str To Dt_dbtimestamp Including Milliseconds

Dec 27, 2007

Hi, I am trying to derive a column from:

mm/dd/yyyy hh:mms.fff to dt_dbtimestamp as:

(dt_dbtimestamp)(colum_name,1, 23) when I include the period and three digits for milliseconds the package fails if I leave it out it is successfull. I need to include milliseconds for my datawarehouse project. I tried many different ways and always with failure
01/23/2007 12:23:15.234 is the date(example) derived: (dt_dbtimestamp)(column_name,1,23) fails
01/23/2007 12:23:15.234 is the date(example) derived: (dt_dbtimestamp)(column_name,1,19) succeeds

Thanks

View 9 Replies View Related

Integration Services :: Exclude Time In Date Time Variable In SSIS For Loop?

Oct 22, 2015

I am trying to load previous days data at 3 am via a SSIS job.

The Date variable is initiated as DATEADD("dd",-1, GETDATE()) in the for loop.

Now, as this job runs at 3 am, and I set the variable as GETDATE() - 1, it excluded the data from 12 am to 3 am in the resultset as Date is set as YYYY-MM-DD 03:00:00:000 I need this to be set as YYYY-MM-DD 00:00:00:000

How can i do this? 

View 2 Replies View Related

Running Ssis Package With Ssis Run Time Compoenents And Sql Server 2000...

Jan 22, 2007

running ssis package with ssis run time compoenents and sql server 2000...

Is it possible to run ssis packages that point to servers on sql server 2000
without installing sql server 2005 ?

Can we just install runtime for ssis and run the packages ?

Please explian with links if possible

thanks a lot

View 18 Replies View Related

First Time SSIS Long Time DTS

May 21, 2008

A few pointers would be appreciated.

I am looking at building multiple SSIS packages. There will be some similarities. Flexibility is of highest importance. The main packages will need to connect to SQL Server1 as a source and SQL Server2 as a destination to transfer over dimenion data from multiple databases. (other SSIS packages may need to use SQL Server2 as a source and SQL Server1 as a destination)

For a single dimension table containing column dim_id on the target server (SQLServer2). I need to pass the results of the following SQL and insert into SQLServer2.database.dim_table

select dim.id
from SQLServer1.database08.dim_table
union
select dim.id
from SQLServer1.database07.dim_table
union
select dim.id
from SQLServer1.database06.dim_table


Now next year the names of the databases on SQLServer1 will be database09,database08,database07!

Now so far my best thought is creating views in my destination SQL Server. So I need some way of dropping and recreating the views. Previously in DTS I would expect to see SQL Server connection that I could use as source and destination. Now I can see SQL Server destination but not source? Also How do I just use SSIS to run some SQL. i.e execute a stored procedure, drop and creat views?

Many thanks,
Ells
p.s Flexibility is the key, in the last three months all the ip and server names have changed more than once so need to be as flexible as possible.

View 2 Replies View Related

Ignore Milliseconds

Mar 7, 2002

Hi
Does anybody know while loading data from text file into sql server, how
can we ignore milliseconds.

regards
JK

View 1 Replies View Related

Truncate Milliseconds

May 8, 2008

I have got data like this below in effective date column
2008-08-05 19:18:13.000
2008-08-05 19:17:10.000

Expected output:
2008-08-05 19:17:10

I need to truncate the milliseconds and insert the same into datetime column.

I tried as below
select convert(datetime,substring(convert(varchar,getdate(),20),1,20))


Thanks in advance

View 9 Replies View Related

DATEDIFF Values Are Different For Exactly Same Milliseconds

Feb 9, 2015

why the results I receiving for Seconds is different? I get the same MS results.

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
Jun 28 2012 08:36:30
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

--Returns 1 second
SELECT RunTime_SEC = DATEDIFF(SECOND, '2015-02-09 13:34:13.977', '2015-02-09 13:34:14.230')
,RunTime_MS = DATEDIFF(ms, '2015-02-09 13:34:13.977', '2015-02-09 13:34:14.230')

--Returns 0 second
SELECT RunTime_SEC = DATEDIFF(SECOND, '2015-02-09 13:30:30.147', '2015-02-09 13:30:30.400')
,RunTime_MS = DATEDIFF(ms, '2015-02-09 13:30:30.147', '2015-02-09 13:30:30.400')

View 6 Replies View Related

Datetime Column With Milliseconds???

Mar 27, 2006

hi ppls..
we have sql server 2000 EM. we received daily xml files and we insert into our database.there is one column Date_T having data type datetime.till date we recieved this records from xml as '03/23/2004 12:23:34:956' but due to some duplicate isssue we now want to modified this column to recieve as milliseconds like '03/23/2004 12:23:34:956232' now my point is wheather sql server handle this kind of milliseconds..please help me out as early as possible..

T.I.A

Papillon

View 9 Replies View Related

Converting Milliseconds In Hours

Oct 16, 2006

Hi!

I have the difference between two dates in milliseconds. I want to convert this difference to the format hh:mm:ss.mmm, without the date. So, if the difference is bigger then one day, I would like to show it like this, for example: 36:25:14.047

How can I do this?



Thank you!

View 5 Replies View Related

Milliseconds From DateTime Column

Nov 5, 2007

Hi,

I am trying to access a date column up to millisecond precession. So I cast date to as follows:



Code BlockCONVERT(varchar(23),CREATE_DATE,121)




I get millisecond part as a result of query but it€™s €œ000€?.

View 5 Replies View Related

Conversion Of Oracle Date Time To Sql Server Date Time In SSIS

Jun 30, 2007

This is driving me nuts..



I'm trying to extract some data from a table in oracle. The oracle table stores date and time seperately in 2 different columns. I need to merge these two columns and import to sql server database.



I'm struggling with this for a quite a while and I'm not able to get it working.



I tried the oracle query something like this,

SELECT
(TO_CHAR(ASOFDATE,'YYYYMMDD')||' '||TO_CHAR(ASOFTIME,'HH24:MM : SS')||':000') AS ASOFDATE

FROM TBLA

this gives me an output of 20070511 23:06:30:000



the space in MM : SS is intentional here, since without that space it appread as smiley



I'm trying to map this to datetime field in sql server 2005. It keeps failing with this error

The value could not be converted because of a potential loss of data



I'm struck with error for hours now. Any pointers would be helpful.



Thanks

View 3 Replies View Related

Can Datetime Type Store Milliseconds

Aug 25, 2006

Hi,
I tried entering this value "8/24/2006 1:35:00.127 PM" with 127 as the milliseconds in a datetime field, but encountered error saying inconsistent datatype ...
Anyone knows how to store datetime value with milliseconds in the SQL database?
Thanks
 

View 13 Replies View Related

Inserting Datetime With Milliseconds In SQL Server

Jul 20, 2005

Hello all.I am attempting to insert a row into a table with a datetime column:When the insert statement contains a value for the millisecond portionof the data time column: ie. {ts '2003-11-05 12:02:43:2960'}I get 'Syntax error converting datetime from string'When I insert a value like: {ts '2003-11-05 12:02:43'}with no millisecond value it succeeds.Any help would be appreciated.Thanks

View 5 Replies View Related

How To Save To Datetime Field Without Milliseconds

Jul 4, 2015

I'm trying to save a datetime value from vb.net to a sql server.I'm using this code: Dim dt As DateTime = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")
After I save this value to Database.But on sql server management studio , I see that the field's value still has the milliseconds .

View 14 Replies View Related

DATETIME, ADO, Parameterized INSERTs And Milliseconds, Oh My

Mar 21, 2008

I want to execute a paramterized ADO insert command into a SQL Server DATETIME column without losing the milliseconds. I can accomplish this without parameters, but that isn't what I want. Any suggestions?

It is OK that DATETIME only has a resolution of 3.33 milliseconds.

See the attached code:




Code Snippet

#include <string>

#include <iostream>

#import "C:Program FilesCommon FilesSystemadomsado15.dll" rename( "EOF", "ADOEOF" )

int main( int argc, char* argv[] )

{

::CoInitialize( NULL );

try

{

ADODB::_ConnectionPtr connection;

connection.CreateInstance(__uuidof( ADODB::Connection ) );


std::string connectionString;


connectionString.append( "Provider=SQLOLEDB;" );

connectionString.append( "Data Source=HPSERV1;" ); // Choose your server/instance.

connectionString.append( "Initial Catalog=tempdb;" );

connectionString.append( "Integrated Security=SSPI;" );

connection->ConnectionTimeout = 10;

connection->Open(

_bstr_t( connectionString.c_str() ),

_bstr_t( "" ),

_bstr_t( "" ),

ADODB::adOpenUnspecified );


std::string sqlStatement;


sqlStatement = "DROP TABLE TestTable1";


try

{

connection->Execute( _bstr_t( sqlStatement.c_str() ), NULL, ADODB::adExecuteNoRecords );

}

catch( const _com_error& )

{

// Ignore errors as table probably doesn't exist.

}


sqlStatement = "CREATE TABLE TestTable1 ( ColInt INT NOT NULL PRIMARY KEY, ColDate DATETIME )";

connection->Execute( _bstr_t( sqlStatement.c_str() ), NULL, ADODB::adExecuteNoRecords );



// ====================================================================

// Works (datetime resolution is 3.33 milliseconds so rounds to .347)


sqlStatement = "INSERT INTO TestTable1 ( ColInt, ColDate ) VALUES ( 1, '2007-12-28 20:05:16.345' )";

connection->Execute( _bstr_t( sqlStatement.c_str() ), NULL, ADODB::adExecuteNoRecords );



// ====================================================================

// Works (NULL is inserted)


sqlStatement = "INSERT INTO TestTable1 ( ColInt, ColDate ) VALUES ( 2, NULL )";

connection->Execute( _bstr_t( sqlStatement.c_str() ), NULL, ADODB::adExecuteNoRecords );



// ====================================================================

// Works (datetime resolution is 3.33 milliseconds so rounds to .347)


sqlStatement = "INSERT INTO TestTable1 ( ColInt, ColDate ) VALUES ( 3, CONVERT( DATETIME, '2007-12-28 20:05:16.345' ) )";

connection->Execute( _bstr_t( sqlStatement.c_str() ), NULL, ADODB::adExecuteNoRecords );




// ====================================================================


unsigned int colInt = 3;

sqlStatement = "INSERT INTO TestTable1 ( ColInt, ColDate ) VALUES ( ?, ? )";


ADODB::_CommandPtr command;




// ====================================================================

// Fails (Operand type clash: ntext is incompatible with datetime)


colInt++;


command.CreateInstance( __uuidof( ADODB::Command ) );

command->ActiveConnection = connection;

command->CommandType = ADODB::adCmdText;

command->CommandText = _bstr_t( sqlStatement.c_str() );

command->Parameters->Append( command->CreateParameter(

_bstr_t(),

ADODB::adInteger,

ADODB::adParamInput,

4,

_variant_t( colInt ) ) );

command->Parameters->Append( command->CreateParameter(

_bstr_t(),

ADODB::adBSTR,

ADODB::adParamInput,

-1,

_bstr_t( "2005-10-25 09:10:11.012" ) ) );


try

{

command->Execute( NULL, NULL, ADODB::adCmdText );

}

catch( const _com_error& e )

{

std::cout << "Error at colInt=" << colInt << " (ADODB::adBSTR and _bstr_t):"

<< " HRESULT = " << e.Error() << ": " << e.Description() << ""

<< " SQL statement: " << command->CommandText << std::endl;

}




// ====================================================================

// Fails (Operand type clash: text is incompatible with datetime)


colInt++;


command.CreateInstance( __uuidof( ADODB::Command ) );

command->ActiveConnection = connection;

command->CommandType = ADODB::adCmdText;

command->CommandText = _bstr_t( sqlStatement.c_str() );

command->Parameters->Append( command->CreateParameter(

_bstr_t(),

ADODB::adInteger,

ADODB::adParamInput,

4,

_variant_t( colInt ) ) );

command->Parameters->Append( command->CreateParameter(

_bstr_t(),

ADODB::adChar,

ADODB::adParamInput,

-1,

_bstr_t( "2005-10-25 09:10:11.012" ) ) );


try

{

command->Execute( NULL, NULL, ADODB::adCmdText );

}

catch( const _com_error& e )

{

std::cout << "Error at colInt=" << colInt << " (ADODB::adChar and _bstr_t):"

<< " HRESULT = " << e.Error() << ": " << e.Description() << ""

<< " SQL statement: " << command->CommandText << std::endl;

}




// ====================================================================

// Fails (A datetime is inserted to table but milliseconds are zeroed)


colInt++;


::SYSTEMTIME sysNow;

::GetSystemTime( &sysNow );


double myTime;

::SystemTimeToVariantTime( &sysNow, &myTime );


// SystemTimeToVariantTime strips milliseconds, so we'll add some more

// back in as we're testing insert of milliseconds.


double desiredMilliseconds = 456;

myTime += desiredMilliseconds / 24.0 / 3600.0 / 1000.0;


command.CreateInstance( __uuidof( ADODB::Command ) );

command->ActiveConnection = connection;

command->CommandType = ADODB::adCmdText;

command->CommandText = _bstr_t( sqlStatement.c_str() );

command->Parameters->Append( command->CreateParameter(

_bstr_t(),

ADODB::adInteger,

ADODB::adParamInput,

4,

_variant_t( colInt ) ) );

command->Parameters->Append( command->CreateParameter(

_bstr_t(),

ADODB::adDate,

ADODB::adParamInput,

-1,

_variant_t( myTime, VT_DATE ) ) );


try

{

command->Execute( NULL, NULL, ADODB::adCmdText );

}

catch( const _com_error& e )

{

std::cout << "Error at colInt=" << colInt << " (ADODB::adDate and _variant_t VT_DATE):"

<< " HRESULT = " << e.Error() << ": " << e.Description() << ""

<< " SQL statement: " << command->CommandText << std::endl;

}

}

catch ( _com_error& e )

{

std::cout << "Unexpected error: "

<< e.Description() << std::endl;

}


return 0;

}



View 3 Replies View Related

Reporting Services :: Convert Milliseconds To HH:MM:SS

Aug 9, 2006

I am writing a report that Queries a SQL DB using 'SQL Server Business Intelligence Development Studio'. I have a field in the DB called duration and it is in milliseconds. I am trying to find an easy way to convert the format from Milliseconds to HH:MM:SS.Nearest I can get is the following for the field:

=Int( ((Fields! DURATION.Value/1000) / 60) / 60) & ":" & Int(((((Fields!DURATION.Value/1000) / 60) / 60) - Int(((Fields!DURATION.Value/1000) / 60) / 60)) * 60)

The output is in HH:MM. One issue with this is if the MM is say :03, it prints as :3. I lose the leading 0 so 9:03 (9hrs and 3 minutes) prints as 9:3. Where as 9:30 (9 hrs and 30 minutes) prints as 9:30 as it should.

View 6 Replies View Related

SQL 2012 :: BCP Output - Remove Milliseconds Part

Apr 18, 2014

I The requirement is to unload all columns data into csv file using bcp with pipe delimiter, but the condition is to remove milliseconds part of a datetime column.

Ex:
2014-02-19 17:12:14.967 remove .967 from data while unloading into csv.

View 1 Replies View Related

SQL 2012 :: Extended Events Duration In Milliseconds Or Microseconds?

Apr 15, 2015

When you view the Extended Events "Watch Live Data" is the duration in milliseconds or microseconds? I'm assuming it's milliseconds, but if you look at the timestamp difference from start to complete it doesn't add up to the duration amount? It looks like it's just the difference between the timestamps?

View 5 Replies View Related

SQL Server 2000 And Milliseconds (datetime Data Type)

Jan 18, 2007

I'm running into a constant issue of SQL Server modifying themillisecond part of a timestamp insert from another application. Theapplication inserts timestamp which includes a millisecond portion as astring (varchar). But when an SQL Server moves this data to anothertable (for reporting), the string is inserted in a datetime field, themillisecond field invariably changes by 1-2 milliseconds for everysingle data point inserted. Given the time critical nature of this data(to a millisecond), its almost impossible to avoid this other than toleave the data as string type. But this drives the analytical reportingfolks wild as report queries based on time criteria are getting messedup. Any ideas how to force SQL Server not to mess around with themillisecond value? Does this problem exist with SQL Server 2005 as well?

View 2 Replies View Related

Round Milliseconds To 2 Decimal Places In 00:02:09:6570000 Format In Sql Reporting Services?

Nov 27, 2007


Start End Duration




11/20/2007 12:05:57 PM

11/20/2007 12:08:06 PM

00:02:09.6570000


Duration =(Fields!end.Value-Fields!startdate.value) i get the output as shown above.

I need to round that output to 2 decimal places and display it as 00:02:09.65

Any ideas?

View 7 Replies View Related

Running SSIS For The First Time

Jun 6, 2007

Hello,



If my SSIS runs every day, how can I "know" that I'm running it for the first time?



I need an SQL Select1 statement to execute the first day that my flow starts (to get all the old data) and after that SQL Select2 statement should always execute (to get the latest data).



How is this possable?



Thank you.

View 14 Replies View Related

SSIS Package Run Time

Mar 6, 2007

Hello all, I have a SSIS package that is importing data from a DB2 database. I am using SSRS (BIDS/VS2005). I want to be able to access the last time a particular package ran in my report, like in the footer of the page. I have found the globals.executiontime for grabbing the time the report was ran.

I want to do the same thing, except I want to call the date/time the last import was made to the database. Is there some easy way to grab that from SSIS, or will I need to maybe reference the DB creation time? (The database is dropped and recreated (for now anyway) in the SSIS package.)



Thanks for your help.

View 1 Replies View Related

SSIS Job Time Out Issue

Jul 24, 2007

I have created a SSIS job using the same SQL query as my old DTS job, which reads data from the source InterSystems Cache database and populates my SQL Server 2005 database tables. There are no data manipulation techniques being applied, just a straight copy. I am receiving the error message below. Can someone help me troubleshoot this issue?





[DataReader Source [1]] Error: System.Data.Odbc.OdbcException: ERROR [HYT00] [Caché ODBC][State : S1T00][Native Code 450] [C:Program Files (x86)Microsoft SQL Server90DTSinnDtsDebugHost.exe] Request timed out due to user timeout at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper90 wrapper)

View 9 Replies View Related

Scheduled SSIS Failing All The Time - Help!

Jun 11, 2008

Hi all. We recently migrated to SQL Server '05 from 2000 and I'm trying to learn SSIS by crash course.

I just wrote an SSIS for one of our nightly processes in Studio 2005. It built with no errors, and the solution and resulting package are saved on the server housing SQL Server.

I ran the package in debug and it completed 100% with no errors. However, when I scheduled the package in SQL Server, it starts and fails.

Now, I'm very new to SQL '05 and I'm trying to figure out how to log the SSIS jobs, but is there any way to find out why the scheduled packages fail?

I'm desperately needing help on this, and any help would be greatly appreciated!

View 3 Replies View Related

Ssis Connection Loss Every Time

Mar 30, 2007

Dear friends,

everytime i used to open the package has a sql server configuration file saved and also has loggin enabled, with password for sensitive data storage given, it shows some errors and all the time the errors are with the created connection.

yes, i have given the right password at the time of opening it.

any idea?

thanks,

View 9 Replies View Related

SSIS Package Taking Much Time Than DTS

Apr 14, 2008



Hi,

I have a DTS in SQL Server 2000, Where I am importing some data from a remote server (SQL 2000) to local server (SQL 2000).And this is working fine. it is taking max of 1 min to execute the package.

Now I have created the same DTS in sql server 2005 (SSIS) where the source server is sql server 2000 and the destination server is 2005.and I have created the ssis in that server. The same logic which i have created in sql 2000. But here it is taking almost 10 min to execute the package.

Where as the same in sql server 2000 taking max of 1 min. Why this happening.. Is there any configuration to execute the SSIS package.?

View 12 Replies View Related

SSIS: First Time Script Component

Nov 29, 2006

Hello,

I have a flat file that contains detail in each record as indicated below:


HEADER_ID, ATTRIB_A(1..10), ATTRIB_B(1..10), ATTRIB_C(1..10), etc.

The index of the attribute relates it to other attributes with the same index. It needs to look like this in the detail table:


HEADER_ID, ATTRIB_A1, ATTRIB_B1, ATTRIB_C1

HEADER_ID, ATTRIB_A2, ATTRIB_B2, ATTRIB_C2

I need to pivot these attributes into a detail table that relates back to the header information. Because of the number of these, I don't want to use the UNPIVOT Task because there are so many. I was hoping to move the complexity to a Script Component where I could read one line and transform it to a normalized state.

Can someone point me in the right direction?

Thanks.

View 6 Replies View Related

SSIS Response Time Very Slow.

Apr 5, 2007

Hi

i had a problem with the SSIS response time - its very slow.

When I try to open the solution and than click to open the Pakage it's take at least 6-10 minutes until it's open.



Please advice what can be the reason

10x



View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved