Error while executing the SSIS package

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Error while executing the SSIS package

Author

Topic

freesoul
Starting Member

35 Posts

Posted - 2007-08-14 : 12:22:47

I migrated the DTS package to SSIS package using the migration wizard...
but when i try to execute it it gives the following error plz help ...

error : Error retrieving file name for a component failed with the error code 0x043A1034

any suggestions ...

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-14 : 22:46:45

What does the package do? are they on same server? How did you execute it?

freesoul
Starting Member

35 Posts

Posted - 2007-08-16 : 06:21:20

package deleted some files in a folder which is in E:\ drive
a small activeX script is written to perform this.

i right clicked on the package and selected "Run Package" but it gives error ..
I made sure that the files are there in that folder by comparing with whats in that folder structure in the production server..

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-16 : 23:19:35

Stored ssis package in sql2k5? Is e:\ a local disk on sql server? Did you run the package on server directly or on client machine?

freesoul
Starting Member

35 Posts

Posted - 2007-08-17 : 03:06:49

Yes e:\ is a local drive on this server(a partition).
and i am running the package on the server only.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-18 : 00:21:34

You can enable package logging to get details.

freesoul
Starting Member

35 Posts

Posted - 2007-09-03 : 11:34:58

Const K_DIR = "E:\FAP_DATA\IN\"

Function Main()

' Delete old files...
DeleteFiles

Main = DTSTaskExecResult_Success
End Function
Sub DeleteFiles()

Dim fso
Dim f
Dim fc
Dim f1
Dim sTemp
Dim sYearMonth
Dim nYear
Dim nMonth

' Initialize objects...
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFolder(K_DIR)
Set fc = f.Files

' Get current month and year...
nMonth = Month(Now) - 1
nYear = Year(Now)

' If month is 0, set it to 12 and decrease the year by 1...
If nMonth = 0 Then
nMonth = 12
nYear = nYear - 1
End If

' Get file name wild-card...
sYearMonth = Right(CStr(nYear),2) + Right("0" + CStr(nMonth),2)

' Delete files...
For Each f1 in fc
sTemp = f1.name
If(Mid(sTemp,8,4) = sYearMonth) Then
f1.Delete()
End If
Next

End Sub

Please help me spot the error .....
Error retrieving file name for a component failed with error code 0x043A1034
I have checked that the files are there for the last month, in the specified folder.

Thanks a lot

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-03 : 13:03:32

How did you run the package? Is e:\ a local drive on the machine where you ran the package? Do you have proper permission to delete files there?

freesoul
Starting Member

35 Posts

Posted - 2007-09-03 : 13:20:18

I ran the package in MS SQL Server Studio, I went to Integration Services --> Stored Packages --> MSDB and selected the Migrated DTS (SSIS Package) and right clicked on it and selected the execute Package option and ran the package .......
and yes the E :\is on this machine only....
which permissions to check to delete file .... i have the admin access to this server....
i think that shud be enough ....
I hope the code is fine .

thanks for the reply .....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources