I have 2 flat files to load into a datamart via SSIS.
Need to implement:-
1. How can I prevent loading of same file again?
2. If by chance wrong data has been loaded how can I rollback?
Kindlt guide asap as I have to implement these.
JigJan
I'm using Script Component to load data into Oracle DB due to the poor performance issue. Now, I found it will missing some data during the transmission. Please see the screenshot below:
SQL Server：
Oracle:
DDL:
create table Person
(
BusinessEntityID Integer,
FirstName nvarchar2(50),
MiddleName nvarchar2(50),
LastName nvarchar2(50)
);
Result:
I follow up this article: [URL] ....
VB Script:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
[Code] ..........
How do u achieve this -- While SSIS Data Load Execution itself?
Update Col B with Col A value if Col B is NULL in the Data File?
I have requirement to load the EDI.TXT format data in SQl server using the SSIS.The edi file data looks like that
@pRecType="A",@pA010="XC",@pA020="270",@pA110="CDC LOCAL"
@pRecType="C",@pC010="M",@pC015="H",@pC050="20080408",@pC060="B",@pC070="E40245",@pC080="P",@pC110="95000",@pC112="000000000",@pC120="P",@pC121="N",@pC122="",@pC124="100000002274",@pC125="166759",@pC210="Y",@pC301="000061131006",@pC320="20080211",@pC321="20080211",@pC511="",@pC512="",@pC900=" ABY"
@pRecType="E",@pE100="1",@pE101="5789",@pE110="",@pE111="",@pE120="",@pE121="",@pE130="",@pE131="",@pE140="",@pE141="",@pE150="",@pE151="",@pE160="",@pE161="",@pE170="",@pE171="",@pE180="",@pE181="",@pE190="",@pE191=""
@pRecType="H",@pH110="8",@pH120="3",@pH130="1",@pH210="",@pH220="20080211",@pH230="20080211",@pH235="01",@pH240="20080211",@pH250="20080211",@pH310="",@pH320="",@pH710="",@pH711="",@pH712="",@pH510="",@pH511="",@pH512="",@pH520="",@pH521="",@pH522="",@pH530="",@pH531="",@pH532="",@pH540="",@pH541="",@pH542="",@pH550="",@pH551="",@pH552="",@pH560="",@pH561="",@pH562="",@pH570="",@pH571="",@pH572="",@pH580="",@pH581="",@pH582="",@pH590="",@pH591="",@pH592="",@pH600="",@pH601="",@pH602="",@pH610="",@pH620="",@pH630="",@pH640="",@pH650="",@pH660="",@pH670="",@pH680="",@pH690="",@pH713=""
@pRecType="M",@pM250="170"
@pRecType="P",@pP010="SE",@pP110="E",@pP130="",@pP150="721153832",@pP210="",@pP310="",@pP340="",@pP350="",@pP360="",@pP370=""
@pRecType="S",@pS010="",@pS020="200278911",@pS110="BABIN",@pS111="JENNIFER",@pS112="L",@pS120="",@pS121="",@pS125="",@pS126="",@pS127="",@pS211="BABIN",@pS212="JENNIFER",@pS213="L",@pS221="F",@pS222="19850919",@pS231="M",@pS310="1605 SOUTH SHIRLEY",@pS311="",@pS315="GONZALES",@pS316="LA",@pS317="70737",@pS410="N"
@pRecType="V",@pV130="AA",@pV140="000000100",@pV150=""
@pRecType="X",@pX010="20080211",@pX020="20080211",@pX131="45378SG",@pX133="5789",@pX134="",@pX141="000095000",@pX142="000000000",@pX147="001",@pX210="0490"
can you help me how I solve this problem.I will appreaite for that id you help me this.
Thanks
HK
Hi,
I am trying to load data from one database to another database with in same sql server.Our DBA has created a new db and I am trying to load data in to this new one.But I am getting error in SSIS packages while scheduled as job. The failed job history was not showing much information So I ran the package dirently to get more info on error message.
I was able to transfer around 5 to 6 tables . But I am unable to transfer the final 2 tables. I am thinking its a space issue. Appreciate if somebidy can explain what the real problem is ?
Below is the error information I got in SSIS
[OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: The specified network name is no longer available. ".
[DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. 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.
[DTS.Pipeline] Error: Thread "WorkThread0" 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 "WorkThread0" has exited with error code 0xC0047039.
Ok, we have built a data mart using SSIS etc...for transformations and loading.
Our biggest single problem we have currently is loading data from an Oracle server to our SQL server. Some tables from oracle run fine when retrieving the data but there is one particular table that just doesn't load fast enough (9 million records take over 12 hours). It seems that we are idling alot and its not always running.
Can anyone help with this problem?
Hello -- I primarily use SSIS for data loading tasks from falt files into SQL Server DB.
I usually have the Loading Fallouts routed to a FALLOUT Table with SSIS Err Codes.
However, the package execution stops if there are a bunch of fallouts.. like more than 20/30..
Is there any place in the package where i can specify a bigger Number, rather than Err'ng out for more than 20/30??
Thank You!
How do i add two extra columns (Filler Columns) @ the end when specifying the "Flat File Connection Manager"
1st Column -- Will carry the File Name from where the record is being loaded
2nd Column -- Load Date
Any thoughts!
I am considering whether SSIS can be used to deal with a formatted report that consists of a number of pages delimited by a control character with rows deleimited by CRLF. There are a number of header records that will need to be removed on each page and each line consists of data in fixed width columns.
The files will be fed to us on a regular basis so we will require an automated solution
Can I use one of the import objects available within SSIS directly to deal with this kind of file or will I have to bite the bullet and start coding a solution using C# or vb.net ?
I am looking to load data incrementally from staging to spectrum database.
Master = Staging table
Detail = Spectrum table
On below logic
.If record from Detail (Spectrum table) is null
then do insert the record into Spectrum table
set status_flag to 'A' for active
else do update the record (replace all old values with new values)
set status_flag to 'A' for active
end-if
· If record from Master (Staging table) is null
then do soft delete
set status_flag to 'D' for delete
end-if
hello
i am performing the ETL on the as400 db2 database using ms- dts,ssis.
i have built the connection b/w as400 and source to extract data from as400 to staging means in dataflow . when i have built the oledb connction for loading data to destination as oledb destination.then it will connct successfully to the db2 as destination but when execute the task then it not load data , and give provider error.
what can be good solution for this.
can u solve it.
rep plz.
I am trying to load a file using SSIS that contains records with two different layouts in one data file but in the flat file connection I can only specify one layout and this is causing the records with the second layout to be loaded incorrectly.
The different record layouts can be identified by the first character of the record. Example: If Field begins with "A" then assign one layout; "B" assign second layout.
Has anybody come accross this issue, if so some guidence would be appreciated.
Thanks,
ire_ssis
It seems I can do the type conversion in two place:
1. The advanced editor for flat file source => Input and output roperties. And I can set the output columns data type properties there.
2. Using a Data conversion box in Data flow transformation.
Any difference between these two? Which one should be used?
Hi,
I have SSIS package which is extracting data from oracle. I am using always use defualt code page =true
and Defualt code page value=1252.
While transferring values in to target table the package is success but when I check the decimal values
For example I have 488.9602 or 56.908 values in oracle table but when they come to SQL server they are rounded as 488.0000 or 56.000.
How can I populate the correct values from source to target
The target table has data type decimal(26,4).
Also when I check in the preview of source table I am able to see correct values. This is happening during the transfer only.
Hi all,
I am new to SSIS...and wanted to know where can i get a lot of info(from web/book) on how to deal with ActiveX Scripttasks & Script tasks in SSIS...the place i am working has a lot of VB Scripting done in DTS Packages...having a hard time in understanding the Scripts, as i am more like back-end guy and wanted to learn a lot in SSIS, once i understand the scripts it will help me a great deal as to how to approach the tasks...Is there any website which teaches how to avoid Scripting in SSIS as i read somewhere that Scripting should be avoided as much as possible by making using of so many tasks in the SSIS tool.
I will look forward for someone to help me out and show me a way.
thanks
ravi
Nothing much that i can do..!!
I am trying to load a dtsx file in the SSIS package ActiveXscript.
But i am getting the following error
Error retreiving the filename for a component failed
In DTS the syntax was
LoadFromStorageFile(UNCFile,Password,[PackageID],[VersionID],[Name],[pVarPersistStgOfHost])
and for SSIS Sql Server 2005 its :
app.LoadPackage("C:ProjectsTestPackage.dtsx", Nothing)
some how its not working for me.Is it because of me using ActiveX scipt
Please help
Thanks in advance.
Hi Everyone:
I have a SSIS Package which in brief moves data from one SQL data store to another. On my local machine, the package executes fines, and does what it is supposed to do, by moving data from Point A to Point B. I have both Point A(DB) and Point B(DB) on my local machine. But when I deploy this package over to ASSEMBLY which is basically another environment, I get weird intermittent errors. What should I do? Can someone give me some tips on how to do good error logging in SSIS? I am currently writing to Windows Event Log, and I seem to look at some errors that are coming thru. What else can I do on SSIS Package side, to improve error reporting and handling, so troubleshooting is faster and more effective. I just need some stable advice on how to setup my package to do error logging where troubleshooting issues in different environments is more effective. Also I need to know, what could be causing these issues? Thanks.
MA
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
else
INSERT TXTfile.KEY into TABLEA.KEY
SSN_Var = EXTRACT the SSN part (SSNpart.READ)
if SSN_VAR.Exists In TableB.AnyRow then
skip
else
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.
Hi,
Can anyone provide me with some sample examples on how to load dimension tables in SSIS. Any help is highly appreciated!
Thanks in advance!
Regards,
Vivek.
Hi,
I'm trying to load 8mm records in SCD type 2 format. the time taken to load these records are very high all most two days with Intel Core 2 processor and 1gb ram
the direct load of 8mm records had taken time up to 12 minutes
can any one guide me up on the memory required for the job to success and is there any performance tuning have to be taken care in mapping.
Please do inform me up on this issue ASAP. Thank you
Hi All,
We are considering loading oracle datawarehouse using SSIS as ETL. I would like to know the experiences of the team in doing the same. Please share your experiences on this.
Thanks,
S Suresh
I'm using an Execute SQL Task Editor to try and load the last load date into a user var. I don't know what I'm doing wrong.
I have result set to Single Row and a simple query:
SELECT LastLoad
FROM HeidtmanDW.dbo.CubeLoadStats
WHERE (SourceTable = 'Sales')
Where do I set the user var User:LastSalesLoadDate (which is scoped to the entire packge)?
Thanks.
Hi All,
We did the development of SSIS packges on 32 bit machine. We have few excel files which is loaded using SSIS.
Now the same was deployed to anothe rmachine(64 bit). This 64-bit machine does not have Microsoft office installed.
And all packages(which loads excel files) failed. Hence can someone answer my following questions:-
1) In order to load excel files using SSIS, is it necessary that Microsoft excel software should be installed on that machine?
2) If answer to above is yes, Can Microsoft excel viewer be used instead of Microsoft office(excel)?
Thanks
Sid
Hi all,
I have problem with SSIS. When I open my packages, I always get an error message which says like this:
There were errors while the package was being loaded.
The package might be corrupted.
See the Error List for details.
And, in error list, I get this error message:
Error loading DIM_BUSINESS_TYPES.dtsx: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'user'.".
But the package itself seems doesnt have any errors at all. When I try to run the package, it runs fine.
Btw, I use package configuration which is stored in sql server table, including the password for connectionstring.
So, what's actually wrong with my package?
Thanks
Currently we are trying to load the xml files into sqlserver tables by using ssis 2012,We are getting xml files as a column in source table ,so we have to push these xml files into destination tables.
I'm following the below way to perform this activity
[URL]
But We have standard XSD structure for all the xml files ,and if xml file matches the XSD structure then only we have to load ,else it should skip to next xml file.
Below is the error, Thanks!!
[Data Conversion 1 [157]] Error: Data conversion failed while converting column "Media Type" (89) to column "Media Type" (201).
The conversion returned status value 4 and status text "Text was truncated or one or more characters
had no match in the target code page.".
[Data Conversion 1 [157]] Error: The "output column "Media Type" (201)" failed because truncation occurred, and the
truncation row disposition on "output column "Media Type" (201)" specifies failure on truncation.
A truncation error occurred on the specified object of the specified component.
[DTS.Pipeline] Error: The ProcessInput method on component "Data Conversion 1" (157) failed with error code 0xC020902A.
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: The PrimeOutput method on component "Source - Test" (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.
I was trying to load SSIS shipped from my colleague. It has configuration file with his SSIS. I added this one to my local project. I removed configuration file from my project. In case anything goes wrong, I also delete OLE DB Connection String, and recreated one. Modified all data flow and control flow for any connection to point to my new one.
After the modification, it still fails on login 'sa'. I cannot figure out the problem. Is there any tricky inside of SSIS configuration file?
I created a package loading Excel file. I developed the package using test excel file c:TestTest.xls and use a config file to assign actual folder (the file names will be got from a foreach loop container) when run it.
However, the package cannot run with a configure file which specify a different source folder and still ask for test.xls. It's not possible that it require reset the folder and file every time when it's used for a new folder.
Information: 0x40016041 at Package1: The package is attempting to configure from the XML file "C:workingFinal3.dtsConfig".
SSIS package "Package1.dtsx" starting.
Information: 0x4004300A at Load Raw1, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0202009 at Package1, Connection manager "Excel Connection Manager": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine could not find the object '\SourceFolderTest.xls'. Make sure the object exists and that you spell its name and the path name correctly.".
Error: 0xC020801C at Load Raw1, Excel Source [1188]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Load Raw1, DTS.Pipeline: component "Excel Source" (1188) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Load Raw1, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Load Raw1: There were errors during task validation.
SSIS package "Package1.dtsx" finished: Failure.
HI
I am transferring the data from sql server 2005 to Informix 7.3.1 SE using SSIS .
I am using the OLEDB data connection for both source as well as destination databases.
I am trying to mapping the source and destination tables .I am getting the following error.
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Destination [184]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Destination [184]]: Opening a rowset for ""srinivas"."company"" failed. Check that the object exists in the database.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
I am using the following ODBC driver for the connecting INFORMIX 7.3.1 which is running on LINUX environment.
Openlink Generic ODBC Driver
It's creates the table in the informix 7.3.1 but it's not mapping the source and destination databases columns.
Please help me any one. it's urgent .
Thanks,
Srinivas Unnam
I am trying to perform an incremental (ProcessAdd) load on a dimension using SSIS and the Dimension Processing data flow component. Whenever I try the load it fails with the following error:
The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:44 PM,12/14/2007 7:44:44 PM,-1055719414,0x,Parser: An error occurred during pipeline processing.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:44 PM,12/14/2007 7:44:44 PM,-1055719414,0x,Internal error: The operation terminated unsuccessfully.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:44 PM,12/14/2007 7:44:44 PM,-1055719414,0x,Errors in the OLAP storage engine: An error occurred while the 'ORDER LINE STATUS' attribute of the 'DIM ORDER LINE' dimension from the 'ACRDvel' database was being processed.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:44 PM,12/14/2007 7:44:44 PM,-1055719414,0x,Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Q DIM ORDER LINE', Name of 'DIM ORDER LINE' was being processed.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:44 PM,12/14/2007 7:44:44 PM,-1055719414,0x,Errors in the high-level relational engine. The data source view does not contain a definition for the 'Q_DIM_ORDER_LINE' table or view. The Source property may not have been set.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:44 PM,12/14/2007 7:44:44 PM,-1055719414,0x,Internal error: The operation terminated unsuccessfully.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:44 PM,12/14/2007 7:44:44 PM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Dimension Processing" (112) failed with error code 0x80004005. 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. There may be error messages posted before this with more information about the failure.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:44 PM,12/14/2007 7:44:44 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0x80004005. There may be error messages posted before this with more information on why the thread has exited.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:46 PM,12/14/2007 7:44:46 PM,-1071636284,0x,The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:46 PM,12/14/2007 7:44:46 PM,-1073450952,0x,SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (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. There may be error messages posted before this with more information about the failure.
OnError,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:46 PM,12/14/2007 7:44:46 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.
OnInformation,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:46 PM,12/14/2007 7:44:46 PM,1074016264,0x,Post Execute phase is beginning.
OnInformation,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:46 PM,12/14/2007 7:44:46 PM,1074016265,0x,Cleanup phase is beginning.
OnInformation,*******,Package,{62F748F0-EFC6-4D7A-9873-B31144C54873},{6AA40F9D-7E89-4D68-B2CD-31A43EA6B80D},12/14/2007 7:44:46 PM,12/14/2007 7:44:46 PM,1074016267,0x,"component "Dimension Processing" (112)" wrote 756860 rows.
Apparently this translates to the error DTS_E_ADDROWTOBUFFERFAILED.
This incremental load is trying to add several hundred thousand rows and it appears to get to around 10K or so and then fail. I can't seem to find any KB articles related to this problem. Does anyone have a clue what may be happening here?
I do have an incremental load of the same type that is working but I am continually getting the following warning when the load is running:
"The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 6 buffers were considered and 6 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked."
My server has 8GB of memory and is running WS 2003 x64 and SSAS 2005 x64
TIA
I load SSIS package using following code:
Application app = new Application();
Package pac = app.LoadFromSqlServer(packageName, serverName, null, null, null);
For simple package containing 2 tasks this code executes about 20 seconds.
If I load old version (SQL2K) package from SQL2000 then it takes 5 seconds.
Is any way to increase loading speed for SSIS packages?
I have an excel sheet that has a bunch of columns. Some of these columns have static data but there are a few of the columns that retrieve data by making calls to servers and returning values that populate these columns. Usually about 30 mins before the columns are populated.
I then need to to load the excel sheet into a table.
I was wondering if there was anyway by which we can make the connection to the excel sheet and then force a delay of about 30 mins before it starts retriving the data?
Is this possible in ssis? Or can I achieve it by some other means?
Thanks for any help in advance
I have just loaded SQL Server 2005 SP1 and it is playing havoc with any SSIS packages that use the File System Task.
I am using the FST to copy a file to a directory after it has been loaded. This worked fine prior to SQ1 but now I am getting the following error if there are one or more files already in the target directory:
[File System Task] Error: An error occurred with the following error message: "The directory is not empty. ".
If I remove all files from the directory it works fine.
Has anyone come across this problem and got a workaround for this? Will it involve me writing a FSO script task???
Is this 'feature' going to be rectified in SP2?