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.
| Author |
Topic |
|
Ginger8990
Starting Member
28 Posts |
 Posted - 2012-04-09 : 18:16:17
|
| I tried to excute some SSIS sample package but I kept getting this error message. I applied all the permission even for child folders:Pre-execute (Error) Messages * Information 0x402090dc: Data Flow Task 1: The processing of file "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\Samples\Integration Services\Tutorial\Exporting ODBC to Flat File\Sample Data\FlatFile.txt" has started. (SQL Server Import and Export Wizard) * Warning 0x80070005: Data Flow Task 1: Access is denied. (SQL Server Import and Export Wizard) * Error 0xc020200e: Data Flow Task 1: Cannot open the datafile "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\Samples\Integration Services\Tutorial\Exporting ODBC to Flat File\Sample Data\FlatFile.txt". (SQL Server Import and Export Wizard) * Error 0xc004701a: Data Flow Task 1: component "Destination - FlatFile_txt" (34) failed the pre-execute phase and returned error code 0xC020200E. (SQL Server Import and Export Wizard) |
|
|
|
|
|
SQL server 2008 R2 64bit