SQLServerCentral / Integration Services / Data Warehousing / SQL Task only passing first character of string to procedure / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 11:44:49 GMT20RE: SQL Task only passing first character of string to procedurehttp://www.sqlservercentral.com/Forums/Topic1426403-364-1.aspx[quote][b]Erin Ramsay (3/4/2013)[/b][hr]Booyah, Lowell! You hit it. I forgot to define the size of my stored proc variables.Good catch![/quote]IIRC, that maximum size for a DOS Path is 512 bytes. Not sure what it is for a UNC but I'd bullet proof the code a bit by making the variables on both ends with a width of at least 512 or maybe even 1024.Mon, 04 Mar 2013 15:28:04 GMTJeff ModenRE: SQL Task only passing first character of string to procedurehttp://www.sqlservercentral.com/Forums/Topic1426403-364-1.aspx[quote][b]Lowell (3/4/2013)[/b][hr]--..I think that's what Phil is going after...bad definition in the Stored procedure.--[/quote]It was indeed :-)Mon, 04 Mar 2013 12:38:24 GMTPhil ParkinRE: SQL Task only passing first character of string to procedurehttp://www.sqlservercentral.com/Forums/Topic1426403-364-1.aspxBooyah, Lowell! You hit it. I forgot to define the size of my stored proc variables.Good catch!Mon, 04 Mar 2013 12:36:30 GMTErin RamsayRE: SQL Task only passing first character of string to procedurehttp://www.sqlservercentral.com/Forums/Topic1426403-364-1.aspxa parameter declared like [b]DECLARE @var NVARCHAR[/b] or [b]DECLARE @var2 VARCHAR[/b] has a size of ONE character...I think that's what Phil is going after...bad definition in the Stored procedure.you would want to explicitly define the size, if that's the case. @var NVARCHAR(255) or whatever is appropriate.Mon, 04 Mar 2013 12:25:17 GMTLowellRE: SQL Task only passing first character of string to procedurehttp://www.sqlservercentral.com/Forums/Topic1426403-364-1.aspxWhat are the parameters defined as in the stored proc definition?Mon, 04 Mar 2013 12:20:29 GMTPhil ParkinSQL Task only passing first character of string to procedurehttp://www.sqlservercentral.com/Forums/Topic1426403-364-1.aspxI've created an ADO.Net connection to a SQL 2005 instance and am using a Execute SQL Task to pass two parameters. FileName (ie. aadc_test) and FilePath (ie. \\\\remoteserver\\directory) to a procedure. The first parameter is defined as string (255) and the second as string (1000) in both the task and the database has those fields as nvarchar(255) and nvarchar(1000) respectively.When the procedure runs it will insert the filename and path into the database but ONLY THE FIRST CHARACTER. So I'll get "a" and "\" in my fields. Can anyone tell me why I'm only getting the first character of my strings?Thanks,ErinMon, 04 Mar 2013 12:17:23 GMTErin Ramsay