SQL String Error when part of package

More
11 months 4 days ago #25492 by prashant
Hi,

I am running in to peculiar error which I cannot troubleshoot

1. This is a simple script which reads tasks from SQL and loops through records, the SQL script is simple SELECT * FROM [basecamp].[del] 
2. When I run this package indivually it works fine

'''
Information     07-08-2025 11:25:32     Started
Information     07-08-2025 11:25:32     Preparing to execute: 01 - New Quick Captures to Basecamp
Information    07-08-2025 11:25:32     Sql: SELECT * FROM [basecamp].[del]
Information     07-08-2025 11:25:32     Loop Value: Rani Maheshwari, PC is not starting in the morning, Vaishnav Nagade to fix  165
'''

3. The Same package when I drag inside another package , I start getting an error 
Information     07-08-2025 11:20:49     Connection Name: Static Masters
Information     07-08-2025 11:20:49     Connection Type is: MS Sql Server
Information     07-08-2025 11:20:49     Success
Information     07-08-2025 11:20:49     Sql: SELECT * FROM [basecamp].[del]
Error   07-08-2025 11:20:49     Invalid connection string attribute
Error   07-08-2025 11:20:49     Failed

4. I then created a NEW SQL script only & tried to import the same within new working package and again it failed

5. I changed from table to query instead , but again same issue, 

 
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
11 months 4 days ago #25494 by Peter.Jonson
Can you provide us with screenshots of the package so we can see which actions you are working with

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
11 months 4 days ago #25496 by prashant
Hi peter,

Please find attached.

 
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
11 months 4 days ago #25498 by Peter.Jonson
Can you post a screenshot similar to this one


 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
11 months 4 days ago #25499 by prashant
Please find attached

 
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
11 months 4 days ago #25500 by Peter.Jonson
Thank you, we will create a special build and email you the link

Peter Jonson
ETL Developer
The following user(s) said Thank You: prashant

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save