Also tried this:

update dbo.VerizonDetails

set totalTime2 = cast(totalTime as time)

but getting error message:

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or time from character string.

I went ahead and replaced the '.' with ':', and reran the update statement:

update dbo.VerizonDetails

set totalTime2 = totalTime

still getting error:

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting...

I tried this:

update dbo.VerizonDetails

set totalTime2 = cast(totalTime as time)

but got the errror:

Msg 241, Level 16, State 1, Line 2

Conversion failed when converting date and/or time from character string.

I'm stuck on this one. Don't know what to do to fix the code. Again I appreciate you posting your comments.

I went ahead and added it in the Import stmt, but still recieving the same error. Can run this successfully on your machine?

Thanks.

This is the error I get when trying to run/debug it:

An error occured while compiling the script for the Script task.

Poject name: ScriptTask_5c78af1250a74913a5bc7015b74ecf16

Error 30002: Type 'System.AddIn.AddIn' is not defined.

Line...

I'm just running on my local machine for development purposes and saving locallyso I don't think its a permissions thing.

Thank you very much for the response.

Basically, all I want to do is insert all the files and filepaths into the table for a given path, For instance C:\program files\. This could be thousands of files.

Heres the table:

CREATE TABLE [dbo].[tblSaveFilePathAndName](

[filePath] [varchar](1000) NULL,

[fileName] [varchar](200) NULL

)

Purpose: We have thousands of files that we need to sort through and find, and quickly identify where those files are...

Awesome! Thank you very much. Really appreciate your help. I owe you a 6 pack. 🙂

Where do I check to see if the transactional rep is set to immediate?

Ok, its transactional.

How can I tell whether its snapshot or transactional? I'm thinking its just transactional, but I'll double check.

I'm guessing @SSIS is the pathname? Why don't you just hardcode the path? This is a great article I found for renaming a file.

http://sqlserversolutions.blogspot.com/2009/04/copyrename-file-using-file-system-task.html