An existing SSIS package has Data source with Data access mode: SQL command from variable. User variable is having select statement as value. Now I added a column to select statement in variable and saved the package. This new column is not showing up in data source columns list. Tried closing the package and reopening it, on doing this I no longer see the new column in variable value select statement too. Looking for solutions other than creating a new variable and calling it in data source.
Aucun commentaire:
Enregistrer un commentaire