Hi,

I m facing the limitation of string variable (only max 4000 characters) to
store my query that need > 4000+ characters.

Any advice for solution?

Thank you in advance.

Daniel

Hi,
Can I have more information about the current logic you are following?

could I know the following

1. Are you using variable for storing query in Control Flow?
2. If using in Execute SQL Task then you can directly provide the .txt file
reference. I mean store your sql in the .txt file and reference that file in
the execute sql task.


Suggestions:

1. How about using a text (.txt file), store your entire SQL in that file
and call that file in ssis by directly assigning the .txt file value to the
object.
2. How about going to custom types?
3. check this
OLE DB Command
The OLE DB Command transformation runs an SQL statement for each row in a
data flow. For example, you can run an SQL statement that inserts, updates,
or deletes rows in a database table.

http://technet.microsoft.com/en-us/l.../ms141138.aspx

Forum posts:
http://forums.microsoft.com/TechNet/...6223&SiteID=17

Hope this helps....

By Harsh Shah

"Daniel" wrote:

Hi,
Can I have more information about the current logic you are following?

could I know the following

1. Are you using variable for storing query in Control Flow?
2. If using in Execute SQL Task then you can directly provide the .txt file
reference. I mean store your sql in the .txt file and reference that file in
the execute sql task.


Suggestions:

1. How about using a text (.txt file), store your entire SQL in that file
and call that file in ssis by directly assigning the .txt file value to the
object.
2. How about going to custom types?
3. check this
OLE DB Command
The OLE DB Command transformation runs an SQL statement for each row in a
data flow. For example, you can run an SQL statement that inserts, updates,
or deletes rows in a database table.

http://technet.microsoft.com/en-us/l.../ms141138.aspx

Forum posts:
http://forums.microsoft.com/TechNet/...6223&SiteID=17

Hope this helps....

By Harsh Shah

"Daniel" wrote:

Hi,
Can I have more information about the current logic you are following?

could I know the following

1. Are you using variable for storing query in Control Flow?
2. If using in Execute SQL Task then you can directly provide the .txt file
reference. I mean store your sql in the .txt file and reference that file in
the execute sql task.


Suggestions:

1. How about using a text (.txt file), store your entire SQL in that file
and call that file in ssis by directly assigning the .txt file value to the
object.
2. How about going to custom types?
3. check this
OLE DB Command
The OLE DB Command transformation runs an SQL statement for each row in a
data flow. For example, you can run an SQL statement that inserts, updates,
or deletes rows in a database table.

http://technet.microsoft.com/en-us/l.../ms141138.aspx

Forum posts:
http://forums.microsoft.com/TechNet/...6223&SiteID=17

Hope this helps....

By Harsh Shah

"Daniel" wrote:

Hi,
Can I have more information about the current logic you are following?

could I know the following

1. Are you using variable for storing query in Control Flow?
2. If using in Execute SQL Task then you can directly provide the .txt file
reference. I mean store your sql in the .txt file and reference that file in
the execute sql task.


Suggestions:

1. How about using a text (.txt file), store your entire SQL in that file
and call that file in ssis by directly assigning the .txt file value to the
object.
2. How about going to custom types?
3. check this
OLE DB Command
The OLE DB Command transformation runs an SQL statement for each row in a
data flow. For example, you can run an SQL statement that inserts, updates,
or deletes rows in a database table.

http://technet.microsoft.com/en-us/l.../ms141138.aspx

Forum posts:
http://forums.microsoft.com/TechNet/...6223&SiteID=17

Hope this helps....

By Harsh Shah

"Daniel" wrote:

Hi,
Can I have more information about the current logic you are following?

could I know the following

1. Are you using variable for storing query in Control Flow?
2. If using in Execute SQL Task then you can directly provide the .txt file
reference. I mean store your sql in the .txt file and reference that file in
the execute sql task.


Suggestions:

1. How about using a text (.txt file), store your entire SQL in that file
and call that file in ssis by directly assigning the .txt file value to the
object.
2. How about going to custom types?
3. check this
OLE DB Command
The OLE DB Command transformation runs an SQL statement for each row in a
data flow. For example, you can run an SQL statement that inserts, updates,
or deletes rows in a database table.

http://technet.microsoft.com/en-us/l.../ms141138.aspx

Forum posts:
http://forums.microsoft.com/TechNet/...6223&SiteID=17

Hope this helps....

By Harsh Shah

"Daniel" wrote:

Hi,
Can I have more information about the current logic you are following?

could I know the following

1. Are you using variable for storing query in Control Flow?
2. If using in Execute SQL Task then you can directly provide the .txt file
reference. I mean store your sql in the .txt file and reference that file in
the execute sql task.


Suggestions:

1. How about using a text (.txt file), store your entire SQL in that file
and call that file in ssis by directly assigning the .txt file value to the
object.
2. How about going to custom types?
3. check this
OLE DB Command
The OLE DB Command transformation runs an SQL statement for each row in a
data flow. For example, you can run an SQL statement that inserts, updates,
or deletes rows in a database table.

http://technet.microsoft.com/en-us/l.../ms141138.aspx

Forum posts:
http://forums.microsoft.com/TechNet/...6223&SiteID=17

Hope this helps....

By Harsh Shah

"Daniel" wrote:

Hi,
Can I have more information about the current logic you are following?

could I know the following

1. Are you using variable for storing query in Control Flow?
2. If using in Execute SQL Task then you can directly provide the .txt file
reference. I mean store your sql in the .txt file and reference that file in
the execute sql task.


Suggestions:

1. How about using a text (.txt file), store your entire SQL in that file
and call that file in ssis by directly assigning the .txt file value to the
object.
2. How about going to custom types?
3. check this
OLE DB Command
The OLE DB Command transformation runs an SQL statement for each row in a
data flow. For example, you can run an SQL statement that inserts, updates,
or deletes rows in a database table.

http://technet.microsoft.com/en-us/l.../ms141138.aspx

Forum posts:
http://forums.microsoft.com/TechNet/...6223&SiteID=17

Hope this helps....

By Harsh Shah

"Daniel" wrote:

Hi,
Can I have more information about the current logic you are following?

could I know the following

1. Are you using variable for storing query in Control Flow?
2. If using in Execute SQL Task then you can directly provide the .txt file
reference. I mean store your sql in the .txt file and reference that file in
the execute sql task.


Suggestions:

1. How about using a text (.txt file), store your entire SQL in that file
and call that file in ssis by directly assigning the .txt file value to the
object.
2. How about going to custom types?
3. check this
OLE DB Command
The OLE DB Command transformation runs an SQL statement for each row in a
data flow. For example, you can run an SQL statement that inserts, updates,
or deletes rows in a database table.

http://technet.microsoft.com/en-us/l.../ms141138.aspx

Forum posts:
http://forums.microsoft.com/TechNet/...6223&SiteID=17

Hope this helps....

By Harsh Shah

"Daniel" wrote:

Hi Shah,

The original idea is to retrieve member list from SQL2005 and transfer the
value into another string variable in SSIS that use to execute against Oracle
DB. Therefore, i need to ensure the member list has no limited to length - so
i select Varchar(max) to store member list. Problem happen in retrieving
SSIS's object value which map to T-SQL's Varchar(max).

Any suggestion to solve about problem?

Thank you in advance

Daniel

"Shah Harsh" wrote: