Click here to Skip to main content
15,886,137 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
chr1s211-Sep-17 4:07
chr1s211-Sep-17 4:07 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
jschell18-Sep-17 12:24
jschell18-Sep-17 12:24 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
Richard Deeming19-Sep-17 1:35
mveRichard Deeming19-Sep-17 1:35 
GeneralRe: Convert String to HEX Format Represents a 32-Bit Signed Integer Pin
jschell20-Sep-17 5:08
jschell20-Sep-17 5:08 
QuestionCannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Member 1150681831-Aug-17 19:32
Member 1150681831-Aug-17 19:32 
AnswerRe: Cannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Richard MacCutchan31-Aug-17 20:56
mveRichard MacCutchan31-Aug-17 20:56 
GeneralRe: Cannot load multiple layers of SWF with Axshockwaveflash due to Adobe Flash security updates Pin
Member 1150681831-Aug-17 21:35
Member 1150681831-Aug-17 21:35 
Questionis not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides Pin
indian14329-Aug-17 13:41
indian14329-Aug-17 13:41 
Hi,

I am getting the following error no matter what path I am giving for this file to load into a Table in the Database from Excel using Jet Engine

The path I have tried are
1. I kept the file on my local machine to run the Package from my Local machine, it said invalid Path (C:\Users\aaleem01\Desktop\Project Documents\Tucker Package\Daily Facets Report 8.21.17.xls)
2. I kept the shared drive/folder, still it gave me in valid file path (Z:\FileWatcher\Daily Facets Report 8.21.17.xls)
3. Then I dropped the file on the Server where Sql Server instance is running and used that path in creating the Connection string for Excel, still it gave me the same error

Can anybody tell me what could be wrong in my file Path, I am trying to execute a Script Task in which I load data from Excel file into a Sql Server Table.

Here is how my Code looks like:

C#
string excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Dts.Variables["ExcelFullPath"].Value + ";Extended Properties=Text;";
                //"" + Dts.Variables["ExcelFullPath"].Value;
                string sqlConnectionString = "Data Source=" + Dts.Variables["ServerName"].Value + ";Initial Catalog=" 
                    + Dts.Variables["Saw_Raw_DatabaseName"].Value 
                    + ";Integrated Security=SSPI;";

                using (OleDbConnection conn = new OleDbConnection(excelConnectionString))
                {
                    if (conn.State != ConnectionState.Open)
                        conn.Open();
                    using (OleDbCommand oleCmd = new OleDbCommand("select * from [" + Dts.Variables["SheetName"].Value + "$]", conn))
                    {
                        using (OleDbDataReader reader = oleCmd.ExecuteReader())
                        {
                            InsertData(Dts.Variables["TableName"].Value.ToString(), reader, sqlConnectionString);
                        }

                        if (conn.State != ConnectionState.Closed)
                            conn.Close();
                    }
                }


The exact error is as follows:

'C:\SSIS Packages\TempFiles\Daily Facets Report 8.21.17.xls' is not a valid path.  Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.


Any type of help can be very helpful like Code snippet, a link or a suggestion. Thanks in advance friends.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

modified 29-Aug-17 19:48pm.

GeneralRe: is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides Pin
PIEBALDconsult29-Aug-17 13:49
mvePIEBALDconsult29-Aug-17 13:49 
AnswerRe: is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides Pin
Richard MacCutchan29-Aug-17 20:52
mveRichard MacCutchan29-Aug-17 20:52 
Questionpie chart report in vb.net Pin
Member 1338013327-Aug-17 1:21
Member 1338013327-Aug-17 1:21 
AnswerRe: pie chart report in vb.net Pin
debasish mishra23-Jan-18 20:38
professionaldebasish mishra23-Jan-18 20:38 
QuestionGUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd16-Aug-17 7:27
gobbo-dd16-Aug-17 7:27 
AnswerRe: GUI from CreateProcessWithTokenW does not show up Pin
Dave Kreskowiak16-Aug-17 12:56
mveDave Kreskowiak16-Aug-17 12:56 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd16-Aug-17 20:12
gobbo-dd16-Aug-17 20:12 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Dave Kreskowiak17-Aug-17 4:58
mveDave Kreskowiak17-Aug-17 4:58 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen17-Aug-17 7:46
professionalEddy Vluggen17-Aug-17 7:46 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd17-Aug-17 9:14
gobbo-dd17-Aug-17 9:14 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen17-Aug-17 11:24
professionalEddy Vluggen17-Aug-17 11:24 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd21-Aug-17 0:07
gobbo-dd21-Aug-17 0:07 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen21-Aug-17 5:04
professionalEddy Vluggen21-Aug-17 5:04 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd21-Aug-17 21:56
gobbo-dd21-Aug-17 21:56 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen22-Aug-17 3:56
professionalEddy Vluggen22-Aug-17 3:56 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
gobbo-dd22-Aug-17 22:50
gobbo-dd22-Aug-17 22:50 
GeneralRe: GUI from CreateProcessWithTokenW does not show up Pin
Eddy Vluggen23-Aug-17 0:00
professionalEddy Vluggen23-Aug-17 0:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.